Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Inserting 13 worksheets into one Excel file

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    NY
    Posts
    1,056
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •