Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Combine Multiple Excel Files Into Single Worksheet of Master Workbook

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Combine Multiple Excel Files Into Single Worksheet of Master Workbook

    I have tried serveral versions of code, provided in these forums, but have yet to find one that works successfully for me. I'm looking to combine numerous excel worksheets, all in separate files (.xls and .xlsx), into one master file on a single worksheet. All of the files to be combined have two tabs (Assessments and Certifications). I need to combine all of the data from the "Certifications" tab of each file, into the master sheet. The first three rows of each file, contain the exact same header information. Any assistance is GREATELY appreciated!

    Thanks!

  • #2
    Re: Combine Multiple Excel Files Into Single Worksheet of Master Workbook

    You probably won't find one that "works sucessfully" for you - just about every import routine is specific to the particular problem. However, they all have common ancilliary code and the main import routine is all that really needs to be changed.

    As you have looked around, perhaps if you provided a link to the code/post that seems closest to your requirements, it shouldn't be too hard to modify.

    Comment


    • #3
      Re: Combine Multiple Excel Files Into Single Worksheet of Master Workbook

      Thanks, cytop. Here is the code i've been working with. It seems to be the closest one that fits my needs. I think...

      http://excel.bigresource.com/Track/excel-bFgAG1Bt/

      Comment


      • #4
        Re: Combine Multiple Excel Files Into Single Worksheet of Master Workbook

        Great Success! After two days of banging my head on the desk, I was able to find something that works flawlessly. I appreciate your help. Here is a link to the code that worked for me...

        http://www.ozgrid.com/forum/showthre...t=36472&page=1

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X