So my dear Excel-ent friends. I need your help to create, what I consider a difficult macro. Here are the circumstances:
1. I create a weekly report of application statuses for work pulling from 5 workbooks.
2. Each workbook has one template and I use filters to show me how many apps are mainframe or distributed (first column filter; only options are MFME or >MFME) and the second column I use a filter for is work in progress or in que (second column; option WIP or InQ)
3. I do this for all five workbooks, each correspoding to a business domain. IN TOTAL I pull 20 numbers.
4. Those numbers are tranferred to a table in the reporting workbook. I then total them under the total columns then create a pie chart for them. I uploaded this screenshot, I hope it will display correctly: weekly report table.PNG
The difficulty I am encounterig is finding the equation/and/or applying it to a macro that will show the amount of rows resulting from each filter.
Example: If I run a filter for MFME apps and a second filter for WIP and 4 results will show. I can see that there are 4 by looking down at the lower left portion of the page or by counting.
I need to link the amount of results into the associated cell on the report worksheet.
If anyone can provide me with input I would greatly appreciate it.