Copying formulas from file to file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Insert an apostrophe to the left of the = sign. This converts the formula to
a text string. Then copy and paste.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Formulas 2
copying groups with formulas 5
Auto Fill Format or Copying Formulas 1
copying excel cells with formulas 4
Copy worksheet to new doc w/formulas not referencing previous doc 4
Copying formulas from one file to another 1
Excel Help to copy information from one row at a time to another sheet 1
Use Macro to Copy and paste formulas from one spreadsheet to anoth 3

Back
Top