Copy sheet to different workbook

  • Thread starter Thread starter 3Nails
  • Start date Start date
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....
 
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.
 
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
 
Back
Top