Copy multiple cells from row& column header intersection

[balaji3081]

Hi All - I am looking for a macro to extract data from multiple (15+ excel files) data file basis an intersection of row col header which is pre defined in the summary file.
In the Data file the row & col headers are same for all (15+) files for a given month, in my summary file criteria keeps changing

Sample data file


Summary file

All items highlited in blue change month over month

 

[balaji3081]

Appreciate if any help can be provided, Thanks

 

[vletm]

balaji3081
You should able to send a sample Excel-files, which has some sample data.
Without that, You should be ready to modify Your original file as someone else has created own version.

Question: in my summary file criteria keeps changing - how?

 

[balaji3081]

Sure will try to make some data sample and post it here

 

[balaji3081]

I have attached the files for refernace - I am need of getting the specific row and column from the 4 product files ( the row and column headers has been called out in the Summary file).

Hope teh sample file makes it easier for coding purpose.

Thanks

 

[vletm]

balaji3081
Please, next time Your sample data files (ProductN.xlsx) would have different data.
Press [ Do It ]-button to get this sample run.