• 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.

Copy multiple cells from row& column header intersection

balaji3081

Member
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
79559

Summary file

All items highlited in blue change month over month


79561
 

Attachments

  • 1655924877601.png
    1655924877601.png
    34.6 KB · Views: 1
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?
 
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
 

Attachments

  • Product1.xlsx
    11.9 KB · Views: 3
  • Product2.xlsx
    11.9 KB · Views: 2
  • Product3.xlsx
    11.9 KB · Views: 1
  • Product4.xlsx
    11.9 KB · Views: 1
  • Summary file.xlsx
    10.9 KB · Views: 1
balaji3081
Please, next time Your sample data files (ProductN.xlsx) would have different data.
Press [ Do It ]-button to get this sample run.
 

Attachments

  • Summary file.xlsb
    17.9 KB · Views: 1
Back
Top