I need to record macros that create the various pivots on the attached sample data. My source data is coming from SalesForce to Excel. The report is exported from SF every week and run on a rolling 52 week time frame. In addition to the screenshot below, I recreate that page with the omitted reasons in their own pivots then make 12 week and 52 week line charts with markers for each.
Since the tables will be created from a different report (but with exactly the same column layout) each time I want the macro to be saved in my personal.xls space so that I can run it each week regardless of the date.
I'm quite tired of doing this manually each week and would be very grateful for any help that will speed up this weekly tedious task. I haven't been able to figure out VBA coding on this level despite all my efforts and am now throwing up my hands and asking for help from the community. I've attached dummy data to illustrate what I need help with.
***I tried uploading the sample data with the pivots already done but the file was too large.
Credit Cycle Screen Cap.JPG
Bookmarks