Copying formulas from one file to another
 

I have 2 spreadsheet files structured the same - same layout, worksheet
names, etc. I have modified formulas in one and want to just copy the
modified formulas to the other file. When I do so, the formulas come in
referencing the cells in the other worksheet. How do I avoid this? I want
them to refer to cells within the target worksheet.

Copying formulas from one file to another
 

Before copying over, select the cells and EditReplace

What: =

With: ^^^

Replace all.

Now copy over and reverse the EditReplace process in both sheets.


Gord Dibben MS Excel MVP


On Thu, 28 Jun 2007 09:56:06 -0700, JGH wrote:

I have 2 spreadsheet files structured the same - same layout, worksheet
names, etc. I have modified formulas in one and want to just copy the
modified formulas to the other file. When I do so, the formulas come in
referencing the cells in the other worksheet. How do I avoid this? I want
them to refer to cells within the target worksheet.