Copying a range of data without adjusting formulas
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?
|