Copy sheet to different workbook

3

3Nails

I need to copy a sheet from one workbook to an existing workbook (not a new
one). I've tried the right click on the tab for the sheet to copy, then Move
or Copy, but the drop down for workbook to "copy to" only list "NEW" and the
one I'm copying from, not the one I want to copy to. I have both workbooks
open, with workbook and sheet protection off. How can I get the one to "Copy
to" list the one I need? Any other way to copy the sheet to an existing
workbook?
 
T

TomPl

Make sure that both workbooks are open in the same occurance of Excel. If
you started excel twice, one occurance may not recognize the other.

Tom
 

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
Merge Multiple workbook sheets into one workbook 0
Copy sheet to different workbook 2
Excel Protection 2
HELP - A formula or sheet you want to move or copy contains the name .... 0
VB Script to copy incremental data from one sheet of workbook to o 1
problems getting this macro to work 23
Formatting problem copying sheet 3

Top