Import Excel File Into Another Worksheet

[The Skipper]

Please advise if it is possible to import and entire worksheet into a worksheet that is already open.

Thanks !!

[The Skipper]

This is how i was able to do it........

1. Open Workbook that is to receive Worksheet.
2. Open Workbook that contains the Worksheet to be copied
and right click the tab of the Worksheet to be exported.
3. Select Move or Copy from the Drop Down Menu.
4. Under "To Book", select the Workbook that you want to receive
the Worksheet and select where in that Workbook you want the Worksheet copied.
5. If you want to leave the original Worksheet in the Exporting Workbook be sure to
select the box "Create A Copy" or the Exported worksheet will be deleted.
6. Click OK to import the sheet.