how do i copy a worksheet to another work book

  • Thread starter multi work book sheet copies
  • Start date
M

multi work book sheet copies

I have a series of workbooks(36) that was a lot of sheets(31). on the
main sheet it looks at each sheets alot of times. I am trying to copy
master sheet to each of the work books with out a reference to the master
workbook
ie
i need something like this ='30'!$C$11
but when i do the copy i get this ='[proget1.XLS]30'!$C$11

how do i copy a whole sheet so i get the first result not the second one?

please i could use some help
Thank you in advance
 
G

Gord Dibben

Select all cells in source worksheet.

Edit>Replace

What: =
With: ^^^

Replace all

Copy the worksheet to the other workbook and reverse the process.

Close source workbook 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

Excel Move or Copy Stopped Working? 0
Copy to another worksheet IF 3
Copy data from one worksheet to another 5
Copy data to multiple sheets 2
WORKSHEET INSIDE A WORK BOOK 1
move worksheet to end of another workbook 3
copy an exact formula without changing cell reference 1
Copy worksheet from one workbook to a master workbook 2

Top