Copy sheet to different workbook
 

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

Copy sheet to different workbook
 

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" wrote:

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

Copy sheet to different 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

"Sheeloo" wrote:

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" wrote:

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