+ Reply to Thread
Results 1 to 1 of 1

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

  1. 08-17-2021, 08:16 AM #1
    sathishkm
    sathishkm is offline
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. VBA helps needed to consolidate data from multiple sheets by matching Column header
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-31-2013, 03:30 PM
  7. [SOLVED] Consolidate text based data across multiple identical workbooks ...
    By rooha in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1