Copying formulas from one file to another

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

Guest

I have 2 spreadsheet files structured the same - same layout, worksheet
names, etc. I have modified formulas in one and want to just copy the
modified formulas to the other file. When I do so, the formulas come in
referencing the cells in the other worksheet. How do I avoid this? I want
them to refer to cells within the target worksheet.
 
Before copying over, select the cells and Edit>Replace

What: =

With: ^^^

Replace all.

Now copy over and reverse the Edit>Replace process in both sheets.


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
Copy worksheet to new doc w/formulas not referencing previous doc 4
Copying formulas with relative references 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy data from once worksheet to another using formula 2
Excel Help to copy information from one row at a time to another sheet 1
COpy formulas from one workbook to another workbook 2
Copy absolute formulas 1

Back
Top