1. Need a MACRO enable excel , Where my ever week added when added in the sheet , My data in other sheet need to get refreshed by a button
2. We have 5 different categories - different aging of the Tickets,
• Incidents reported in the last week.
• Throughput for the last week
• Incidents pending for closure in last week
• Incident backlog - Prior to the reporting week
• Incident backlog -including reporting week
So all these 5 categories comes under different rules
What i am looking is , as of now we are doing all the work manually , with a PIVOT rules, Extracting RAW data and applying PIVOT table and going to each category and changing each . To avoid this , I need a macro enabled sheet with each rule pre-defined to each category.
UPLOADED THE FILE FOR YOUR REFERENCE WITH THE EXAMPLE AND SCREENSHOT