Importing worksheet from different workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I import worksheets from a different workbook? I have a number of
sheets and I'd rather not make new sheets, then copy and paste the data.

Thanks in advance for your help.
 
Hi Wes,

With both workbooks open,:

Rightclick the tab of the sheet to be exported,
Move or Copy ...
In the first dropdown select the recipient book
In the second dropdown, specify the position for the exported sheet
Repeat for each sheet to be exported.
 
You must log in or register to reply here.

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
Need to merge worksheets - Excel 2003 0
How to extract email addresses from 1 worksheet to another workbook 11
problems getting this macro to work 23
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
import multiple excel books to one excel workbook 3
A macro code to print multiple sheets in different w.books 3
Merge Multiple workbook sheets into one workbook 0

Back
Top