copied formulas refer to destination sheet not source sheet

[Dantron]

In a workbook, with a master sheet copied many times, how do I copy formulas
from one sheet to another and have those formulas refer to the destination
sheet rather than refering back to the source sheet. I seem to remeber this
in the distant past but can't remeber how to make these formulas refer to the
destination sheet and not the source from whence they were copied.

 

[Gord Dibben]

If just copying cells there should be no problem.

Copying a formula like =A1+B1 will not need to be changed since it doesn't
refer to any source.

But if you are copying the Master sheet by Right-click>Move or Copy then you
will get reference to Master sheet.

One method is to do an Edit>Replace before copying Master sheet.
Replace what: =

With: ^^^

Copy Master sheet then reverse the edit>replace in both sheets.


Gord Dibben MS Excel MVP

 

[Michael Arch]

The easiest way is to have the sheets named the same, and when you do the
pasting, do paste special -> Formulas
--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.