Macro to Lookup values using Match

[Viswa123]

Hi All,

I need to create a Macro which would lookup the values from an another excel using the headers.

The master excel would have the lookup values and the headers. Ideally the macro should lookup the values from another excel 'data' and match the headers in the excel 'data' to the master excel. The excel 'data' would have multiple sheets. So the macro would have to go through all the sheets in the data to lookup and match the headers into the master excel.

I am not able to upload the files as these are confidential data.

Thanks

 

[vletm]

Viswa123
Is it true that You not able to upload even a sample Excel-file, which is same kind of file as Your confidential file?
... as well as You should able to show - how would You use it and Your expected results someway.