Background: We have an excel with data updated weekly by our central team. HQ replaces the 2nd previous week data rather than just adding it. We can not change this. For example, in calendar week 7, they add calendar week (CW) 6 of data, and they remove calendar week 4. Leaving only 2 weeks of data at a time. It is set as a pivot table filtered via slicers.
What I want to do with vba is this: I want to be able to run the macro, in which it selects the exact same 4 slicer items in their respective slicers, and a 5th slicer, in which it selects the top listed slicer item (the oldest CW data available). In the end posting the filtered/sliced data into another excel to become a historical database.
Lmk if any questions: Would be a huge help.
Cheers, Shane
I can no problem set a source and target workbook, select the data I want from the source and post to the end or where I want in the target. My problem comes when filtering via slicer. Which is our only option. Goal is to be able to just run the macro once a week, and it does it all.