How do I copy formulas from 1 wrkbk to another w/o absolute refs

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

Guest

I am trying to copy a summary from one workbok to another. How do I copy
with out absoute references to the source workbook?
 
Mike
Select the range you want to copy. Then click on Edit - Replace. In
the "Find what:" block, type the equal sign "=" (without the quotes). In
the Replace with block type some text that you know you don't have in your
range, like $$$$$. Click OK.
Now all the formulas in your range are no longer formulas. Copy and
paste.
In the destination sheet, select the range you just pasted. Do Edit -
Replace and replace the "$$$$$" with "=". Done. HTH Otto
 
You must log in or register to reply here.

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

Transposing a cell down a colum 2
Copy absolute formulas 1
Excel 2007 - combining worksheets to use for a mail merge 1
How to create absolue path link to another workbook (Excel 2003) 1
Ref Formula Query 1
Copy formulas to another workbook 4
Use Macro to Copy Formula from one Workbook to another 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top