Copy a worksheet from one file to another

B

benny.watt

I have 5 identical Excel workbooks.

I created a worksheet on one of the files, which consists totally of
references to various cells in the existing sheets.

I want to copy this sheet to the other 4 Excel workbooks, however the
references point to the original file and its cells, not the one I am
adding it to.

How is this possible?
 
B

BoniM

Its really trying to be helpful...
To fix it:
Copy it to one of the other workbooks, with the new sheet the active sheet,
click Edit - Replace. In the Find box, type [old workbook name] - the way it
appears in the cell references and leave the replace box empty.
Click Replace All and they should now work the way you wanted...
 

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

Cannot copy worksheet to another file 2
Merge Multiple workbook sheets into one workbook 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy formulas to another workbook 4
How to extract email addresses from 1 worksheet to another workbook 11
Copy Worksheet 1
Copy data from unlocked cells 3
Copy and Pasting to Another Workbook 1

Top