copy formula to new workbook without [REFERENCE]

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

Guest

I need to copy a whole series (3x30 range) of formulae from one workbook to
another. I'd like to copy without the reference to the original workbook. Is
this possible?

signed: frustrated...
 
What I do for simplicity's sake:

Copy all the formulas over
Go into the address bar for one of the cells.

Copy everything from the initial ' to the second '

get out of the cell

Edit/Find/Replace

Paste what you copied in the find

Replace with blank

OR, if reference is to a different tab, replace with tab name.
 
To use Excel, you need to be a buddhist. Imagine the sound of one hand
clapping. :-)

Thanks for the feedback...
 
Back
Top