Copying formulas from one file to another

J

JGH

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.
 
G

Gord Dibben

Before copying over, select the cells and Edit>Replace

What: =

With: ^^^

Replace all.

Now copy over and reverse the Edit>Replace process in both sheets.


Gord Dibben MS Excel MVP
 
Top