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