Copy sheet to different workbook

[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....

 

[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.

 

[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