Thread
:
Copying a range of data without adjusting formulas
View Single Post
#
6
Posted to microsoft.public.excel.misc
Captain Jack Flak[_2_]
external usenet poster
Posts: 2
Copying a range of data without adjusting formulas
if the formula in C1 references A1, and I copy a range of cells including C1
to another location and C1 winds up being M1 I still want the formula to
reference A1, but for a variety of reasons I prefer not to use absolute cell
references. This used to be very easy in 123 and in another lifetime
Supercalc5
other spreadsheets.
"Tyro" wrote:
What do you want? For example if the fomula in cell B! references cell A1,
what should it reference after you copy it to, say, cell M16?
Tyro
"Captain Jack Flak" <Captain Jack
wrote in
message ...
I often have to create several versions of a report that summarizes data in
slightly different ways. It is easiest to do this by copying an existing
form to another section of the same worksheet, however I cannot stop the
formulas from "adjusting". This is not a case where I want to use
absolute
cell references. Other spreadsheets have a way to copy a range of cells
without "updating" the cell references within the formulas. Is anyone
aware
of a procedure or option, when copying a range of data, that will prevent
references within formulas from updating?
Reply With Quote
Captain Jack Flak[_2_]
View Public Profile
Find all posts by Captain Jack Flak[_2_]