Copying Formulas

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

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
 
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
 
Back
Top