Copying formulas from file to file

[Guest]

My company has some tracking spreadsheets with complex formulas. We were
trying to copy the formulas from one file to another. When we did so, we ran
across a problem: rather than simply copying the formulas over and using the
relative cells in the new spreadsheet, the formulas were still referencing
the cells from the old spreadsheet.

Is there a way to simply copy the formulas and have them reference the
relative positions in the spreadsheet being copied to, and if so, how is that
done?

 

[Guest]

Insert an apostrophe to the left of the = sign. This converts the formula to
a text string. Then copy and paste.

 

[Gord Dibben]

Jeremy

A workaround method..........

In source worksheet go to Edit>Replace

What: =

With: ^^^

Replace all.

Copy across to target file then reverse the process.

Close source file without saving.


Gord Dibben MS Excel MVP