copying formulas from one file to another
Beautiful! Thank You.
"Gord Dibben" wrote:
One method.
Select cells.
EditReplace
What: =
With: ^^^^
Replace all.
Now make the copy to the new workbook.
Reverse the EditReplace process.
Gord Dibben MS Excel MVP
On Tue, 1 Aug 2006 15:01:02 -0700, Loris
wrote:
I have a master worksheet that pulls data from other worksheets in the
workbook. I want to copy those formulas to other workbooks which have
different text in them so I can't just make copies of the original file.
However, I don't want the target workbooks to refer back to the original
file, only to the same worksheets within each workbook that the original
workbook referred to. How do I do that?
|