Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    May 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merging multiple Excel files

    Hi,

    I would like to merge the atatched files so that they are both in the same spreadsheet.

    I have over 100 hundred of these files to merge , so would like a quick way to do this.

    I would like to keep all the headers.

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 10 Times in 9 Posts
    Is the Quote number going to stay with each line item?
    PJ in FL

  3. #3
    New Lounger
    Join Date
    May 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yes it is.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    What do you want the finished merged file to look like?

    Steve

  5. #5
    New Lounger
    Join Date
    May 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    is does not matter as long as files are merged

  6. #6
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 10 Times in 9 Posts
    Can you provide the format you want the final sheet to look like - i.e. headers with quote number included?
    PJ in FL

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps you can adapt this code:
    http://windowssecrets.com/forums/sho...l=1#post617886

    Steve

  8. #8
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 10 Times in 9 Posts
    Try the attached master database file. The macro runs when ctrl-shift-G is pressed.
    Attached Files Attached Files
    PJ in FL

Posting Permissions

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