Inserting 13 worksheets into one Excel file

ar · Mar 28th, 2002, 09:29 AM

I have 13 separate Excel files that all need to go into one Excel file with each of the 13 Excel file having its own worksheet, that is, the new Excel file with have 13 worksheets. The method I use is to insert a new worksheet then copy one of the 13 Excel files and paste it to the worksheet. I then repeat this process until I’m finish. I was wondering if there is a faster method. Thanks.

Bob Umlas · Mar 28th, 2002, 10:15 AM

Why not use each workbook's sheet like Sheets(1).Copy After:=Thisworkbook.Sheets(Thisworkbook.Sheets.Count)
for example.

Quote:

On 2002-03-28 08:29, ar wrote:
I have 13 separate Excel files that all need to go into one Excel file with each of the 13 Excel file having its own worksheet, that is, the new Excel file with have 13 worksheets. The method I use is to insert a new worksheet then copy one of the 13 Excel files and paste it to the worksheet. I then repeat this process until I’m finish. I was wondering if there is a faster method. Thanks.

ar · Mar 28th, 2002, 10:37 AM

How do I use the "Sheets(1).Copy After:=Thisworkbook.Sheets(Thisworkbook.Sheets.Count)" feature.

Juan Pablo González · Mar 28th, 2002, 10:51 AM

There is not a faster method without using VBA. You have to move each one manually.

GeorgeB · Mar 28th, 2002, 12:35 PM

Hi ar
I do this all the time but manually. There is a better way than what you described. If you need some help just repost.
George

Mar 28th, 2002, 10:51 AM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	There is not a faster method without using VBA. You have to move each one manually. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 09:29 AM	#1
ar New Member Join Date: Mar 2002 Posts: 24	I have 13 separate Excel files that all need to go into one Excel file with each of the 13 Excel file having its own worksheet, that is, the new Excel file with have 13 worksheets. The method I use is to insert a new worksheet then copy one of the 13 Excel files and paste it to the worksheet. I then repeat this process until I’m finish. I was wondering if there is a faster method. Thanks.

Mar 28th, 2002, 10:37 AM	#3
ar New Member Join Date: Mar 2002 Posts: 24	How do I use the "Sheets(1).Copy After:=Thisworkbook.Sheets(Thisworkbook.Sheets.Count)" feature.

Mar 28th, 2002, 12:35 PM	#5
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Hi ar I do this all the time but manually. There is a better way than what you described. If you need some help just repost. George