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

Turning off automatic calculation 0
Dumb question alert! What program to use? 0
How to copy files from Onedrive account to another 2
problems getting this macro to work 8
Space at end of multi page list to accommodate new entries 1
Copy sheet to different workbook 2
How to make repeating drop-down lists? 2
Save workbook without shapes 0

Top