ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Import worksheets from another workbook? (https://www.excelbanter.com/excel-worksheet-functions/227511-import-worksheets-another-workbook.html)

bjwheeler

Import worksheets from another workbook?
 
A coworker sent me his Excel workbook, and I want to import specific
worksheets into my workbook, as if to merge them, so they're located in the
same workbook. I can't figure out how to do this. Is it possible?

Ron de Bruin

Import worksheets from another workbook?
 
Hi bjwheeler

Select the sheets with your Ctrl key down
Right click on the selected sheets tabs
Choose Move Or Copy
Check the create a copy box and choose your workbook in the To book dropdown

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"bjwheeler" wrote in message ...
A coworker sent me his Excel workbook, and I want to import specific
worksheets into my workbook, as if to merge them, so they're located in the
same workbook. I can't figure out how to do this. Is it possible?



All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com