View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Learning Excel Learning Excel is offline
external usenet poster
 
Posts: 98
Default Copying a range of data without adjusting formulas

Got to go. Hoping someone get the me good answer, will be appreciate it.
Thanks .
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Captain Jack Flak" wrote:

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?