• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Consolidation of Sheets with Different column Headers

D

DVI

New Member
I need help to merger 18 sheets of data ,all have the same kind of data only catch is that every sheet has a different header nomenclature
Like all 18 sheets have different ways of having the nomenclature for a column headers

I need the VBAcode to search the header n copy these columns and paste as per my target sheet header column and add the sheet name under NC parameter column
(My Settings sheet has the headers i need marked in yellow for each sheet tab , need to match the result sheet and paste that column , by appending data row wise )

Any VBA code would be of great help in reducing manual work . Appreciate your help in this regards.

Thanks in advance
 

Attachments

  • Merger sheets Sample.xlsx
    72.5 KB · Views: 3
As this is a wild cross posting so according to any Excel forum rules​
you must add a link to each same thread created on any other forum …​
​
 
You must log in or register to reply here.
Back
Top