+ Reply to Thread
Results 1 to 4 of 4

Appending Multiple Excel Sheets

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    canada
    MS-Off Ver
    Excel 2012
    Posts
    1

    Appending Multiple Excel Sheets

    Hi All,

    I working with multiple excel files, each having a 5 spread sheets each. I am trying to append the second sheet onto the first one, and so on down the list of some 400 excel sheets. My problem is that there are multiple columns per sheet, and each sheet contains different data then the last. What I want to do is basically take the first excel file, and append the data from each sheet onto the bottom row of the corresponding row. I hope I am making sense with the explanation, I am trying to write a perl script to do this, but I am having problems, and I am hoping someone else had this situation. And fyi, I didnt organize these files like this, the data came from a outside source who were not thinking propelled.

    Cheers & Thanks,
    Krizbomb

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Appending Multiple Excel Sheets

    http://www.rondebruin.nl/copy2.htm
    If solved remember to mark Thread as solved

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Appending Multiple Excel Sheets

    Sounds like an interesting problem.

    Do I understand you right when I assume that you wish loop through all 400 files in a folder and add all information from the second sheet to the first sheet. Then close this file and repeat the process with the next file in the folder?

    After having copied data from first to second sheet should second sheet be deleted?

    Is the number of columns the same in both sheets?

    What are the names of the first and second sheet?

    Alf

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Appending Multiple Excel Sheets

    Hi Krizbomb,

    welcome to the forum.

    Suggest you to search internet for "excel consolidate worksheets into one" and you'll get codes to achieve this. thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1