How do I delete the refernce a formula when copying and pasting?

L

Lora

When I copy from one workbook to another, the reference is copied. How do I
delete
the reference part of all my formulas on a sheet? Example:

='[4trial 2008 Wkly Summary.xlsx]WklyInfoA868'!D23

I just want: =WklyInfo868!D23 to show up in the cell. I need this
to occur
for all the formulas copied on this sheet.

Suggestions!
 
G

Gord Dibben

In target workbook Edit>Links and change source to target workbook.

Another easy method is to do an edit>replace in the source sheet.

Replace what: =

Replace with: ^^^

Replace all.

Copy the range over to target workbook then reverse the process in both
books or just in target book and close source book 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 and pasting with SUMIF and COUNTIF 3
sumproduct error when adding new sheet 4
How do I edit several formulas at one time in a worksheet? 2
how do I invoke formula pattern copying? 4
Sumproduct help 11
How do I use wildcard characters in Excel 2003 sumif formula? 1
formulas copying from sheet to sheet 6
Formula for Next Sheet and Every Other Cell 12

Top