Copying Formulas

[Chad Cameron]

Hi All,

This isn't a programming issue but a Formula issue.

I want to copy a group of formulas from 1 workbook to another. When I do,
it references the prior workbook. Is there a way to paste a group of
formulas but have them refence the sheets & cells of the current workbook?

I tried paste special -> Formulas

Thanks
chad

 

[Gord Dibben]

You can re-direct links after the fact using Edit>Links and changing the
source workbook to current one.

Or you can edit before copying.

Edit>Replace

What: =

With: ^^^

Replace all.

Copy to new workbook then reverse the edit/replace.

Close old workbook without saving.


Gord Dibben MS Excel MVP