ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert several Excel files into existing Excel file? (https://www.excelbanter.com/excel-discussion-misc-queries/122227-insert-several-excel-files-into-existing-excel-file.html)

Jugglertwo

Insert several Excel files into existing Excel file?
 
Is there a way to insert another Excel file into an existing Excel file?
A student recently asked and it got me to thinking.
The only thing that seems to work is the old copy and paste.
I know in Word you can insert a file and when I tried this in Excel it ended
up inserting the file as an embeded object.
they have several lists in separate files and would like the quickest way to
combine them into one big list.
Any suggestions and/or resources to check out would be appreciated.
Thanks!
Jugglertwo

Dave F

Insert several Excel files into existing Excel file?
 
What's wrong with copy and paste?
--
Brevity is the soul of wit.


"Jugglertwo" wrote:

Is there a way to insert another Excel file into an existing Excel file?
A student recently asked and it got me to thinking.
The only thing that seems to work is the old copy and paste.
I know in Word you can insert a file and when I tried this in Excel it ended
up inserting the file as an embeded object.
they have several lists in separate files and would like the quickest way to
combine them into one big list.
Any suggestions and/or resources to check out would be appreciated.
Thanks!
Jugglertwo



All times are GMT +1. The time now is 01:26 PM.

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