• 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

vletm

Excel Ninja
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?
 
Top