You're welcome, and thanks for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Captain Jack Flak" wrote in
message ...
Thank you... this will work.

"Ragdyer" wrote:

The easiest way is to "unformula" your formulas.

Change them to text strings, copy, paste in the new location, then return
them to being formulas.

Replace the equal sign with something unique so that XL doesn't recognize
them as formulas.

For example:
Select the cells in question, then,
<Edit <Replace
In "Find What" enter the equal sign ( = ),
In "Replace With" enter
^^^
Then <Replace All

While the cells are *still* selected,
Right click in the selection and choose "Copy",
Navigate to the new location and paste them.

Then, reverse the procedu
<Edit <Replace
In "Find What" enter
^^^
In "Replace With" enter the equal sign
=
Then <Replace All

All references remain unchanged.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"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?