Consolidate data from different sequence headers

[ashish mehra]

Hi all,

I am exporting data from server & got no control on other team; to fix column header position in all the sheets.

I would like to get help on consolidation of data from same workbook containing different sequence of headers in each worksheet.

Working:

Every worksheet contains about 50-70 column & matching columns are 25-30. I am sharing a sample file.

A) I want a code to copy the data from each worksheet that matches column headers.
B) I want to copy data row wise & some of the column/cells are blanks.
C) I think we need to insert a unique column header in each worksheet.

Regards,
AM

 

[Hui]

A SQL Based solution won't care about header positions only field names
or using a VBA Based solution you can allow for differing field positions

I would start by using the Search Box at the Top Right of this page
Search for merge worksheets sql