Copy sheet to different workbook

3

3Nails

I need to copy a worksheet to a different existing workbook. I have tried the
right click on tab, then Move / Copy, but the drop down list does not include
the workbook I am trying to copy to, only the one I'm copying from and "NEW".
I have both workbooks open and unprotected, as well as the worksheet
unprotected. Any ideas? Thanks....
 
S

Sheeloo

You should get all open workbooks in the drop down. Pl. check again.

Also go to another workbook and see whether you get the complet list in the
dropdown..

As a workaround -
You can always select the whole sheet and copy into a blank sheet in another
workbook.
 
3

3Nails

Thanks, Sheeloo. I was opening the other workbook up in a different Excel
application. When I open up both workbooks within the same Excel application,
then they both appear in the drop down box.

Thanks again...Keith
 

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

Copy sheet to different workbook 1
Excel Move or Copy Stopped Working? 0
Merge Multiple workbook sheets into one workbook 0
Excel Protection 2
Excel 2003 Break Links 3
How to extract email addresses from 1 worksheet to another workbook 11
Copy sheet to different workbook sizing error message 2
Combine multiple workbooks into one workbook 1

Top