Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Combine Multiple Excel Files Into Single Worksheet of Master Workbook

  1. #1
    Join Date
    23rd August 2011
    Posts
    3

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,916

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    23rd August 2011
    Posts
    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/

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    23rd August 2011
    Posts
    3

    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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: June 8th, 2008, 10:09
  2. Combine/Merge Multiple Single Sheet Files Into One
    By TheAnswer1313 in forum EXCEL HELP
    Replies: 2
    Last Post: April 15th, 2008, 02:48
  3. Replies: 12
    Last Post: April 20th, 2007, 01:54

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
  •  
porno