Inserting 13 worksheets into one Excel file

[ar]

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.

 

[BobUmlas]

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

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]

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

 

[Juan Pablo González]

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

 

[GeorgeB]

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