copying formulas from one file to another
 

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?

copying formulas from one file to another
 

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?

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?