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.




"Dantron" wrote:

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.