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
27 freelancer bu iş için ortalamada 2583₹ teklif veriyor
I have already such type of project in VBA. I have 5 yr plus experience in Macro development in CBA. I will create Single button and after clicking this you will get output fraction of seconds. Thanks Rohit