Hi,
As per the mentioned scenario, I already designed a macro in my head.
because, kind of scenarios I tackle in office on a daily basis. but before I fount, here is my introduction:
I have given my job description below.
Well, I am working in Pravate firm as a VBA Developer. My routine work is to identify scope for the improvement in reporting, standardize and modifying new Reports.
We have Automated almost every Daily and weekly reports and made it user friendly. So, No matter how difficult the report is, it will get prepared by just uploading the Raw data and click on single button and then relax. VBA will show magic here.
After few seconds, user will get confirmation popup that your report has been prepared.
I have arranged dynamic data. No issue even the reports gets changed that code would work perfectly.
This what I do in office...
Please revert if you need any other information.
Thank you
Regards,
Vikaskumar Singh