Importing worksheet from different workbook
 

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.


---
Regards,
Norman



"Wes" wrote in message
...
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.

Thanks. (That was so obvious I feel stupid for not knowing.)

"Norman Jones" wrote:

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.


---
Regards,
Norman



"Wes" wrote in message
...
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.