+ Reply to Thread
Results 1 to 1 of 1

Need VBA code to consolidate multiple excel workbooks based on matching the column names

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    460

    Need VBA code to consolidate multiple excel workbooks based on matching the column names

    Hi,

    Please help me with the VBA code to consolidate the excel multiple excel workbooks kept in a particular path and also should collate the data based on the matching the correct names as there might me column names interchanged in few of the file.

    attached the sample file and required output.

    awaiting for good VBA code
    Attached Files Attached Files
    Last edited by sathishkm; 08-25-2021 at 05:44 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code: Consolidate multiple workbooks into one workbook
    By LukeVBA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2019, 12:37 AM
  2. Consolidate Multiple Workbooks With Same Column Header into 1 Master Workbook
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2016, 02:55 PM
  3. VBA Code to consolidate sheets from multiple workbooks into one workbook
    By d247 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-10-2014, 02:53 AM
  4. Consolidate data from multiple files in a directory by matching column headings
    By ezra_kirivann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2014, 11:46 AM
  5. [SOLVED] Consolidate cells with multiple names into a single column with one name per cell
    By rbtx70 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2013, 12:16 PM
  6. Replies: 12
    Last Post: 01-31-2013, 03:30 PM
  7. Replies: 1
    Last Post: 01-08-2013, 03:47 AM

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