How to copy formulas between workbooks w/0 referencing source?

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

Guest

I am struggling to copy math formulas from one workbook to another. I only
want the formulas to reference specific sheets in the active workbook.
 
Are you saying that you want to copy the cells and keep the formulas
referencing the same cells? If so one way would be to replace the equal sign
and copy the text string of the formula then reverse the replace

Ctrl h, find what put =
replace with put ^=^

replace all, copy over the data, then reverse and replace ^=^ with = in both
places
 

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

copied formulas refer to destination sheet not source sheet 2
Excel not copying formula reference to original workbook 7
Referencing text in merged cells 1
Copying cell with input range to different worksheet 4
Referencing formula using Indirect 4
Excel Protection 2
Worksheet relative reference 3
How to copy & paste a worksheet but change 1 bit of the formula? 1

Back
Top