Shereena Kareem
New Member
Hi Friens,
I have 30 excel files in a folder. i need to consolidate these files based on its header. for example in first file the first name in column "C", but in second file the first name is in Column "E". I need this two first name fields in Column "A" of the Master sheet.I have a macro to consolidate all the excel file in a folder. But this macro does not consolidate excel files as per header. Any help will be appreciable.
Thanks
Shereena
I have 30 excel files in a folder. i need to consolidate these files based on its header. for example in first file the first name in column "C", but in second file the first name is in Column "E". I need this two first name fields in Column "A" of the Master sheet.I have a macro to consolidate all the excel file in a folder. But this macro does not consolidate excel files as per header. Any help will be appreciable.
Thanks
Shereena