copying formulas from one file to another

[Guest]

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?

 

[Gord Dibben]

One method.

Select cells.

Edit>Replace

What: =

With: ^^^^

Replace all.

Now make the copy to the new workbook.

Reverse the Edit>Replace process.


Gord Dibben MS Excel MVP

 

[Guest]

Beautiful! Thank You.

One method.

Select cells.

Edit>Replace

What: =

With: ^^^^

Replace all.

Now make the copy to the new workbook.

Reverse the Edit>Replace process.


Gord Dibben MS Excel MVP