I found some code that will loop through a pivot table, apply a particular filter, and repeat until all filters have been applied. I need to scale this code to multiple pivot tables located in different Sheets. So the order of operations would be:
- Filter PT 1
- Filter PT 2
- Filter PT 3
- Save report as ____
- Filter PT 1
- Filter PT 2
- Filter PT 3
- Save report as ____
Until all filters have been cycled through on each PT. The filter is always on the same field and should always loop the same number of times for each PT, so it's only a matter of making sure it does the same operation for each PT on each Sheet. There are three Sheets that I need to do this for. I don't know if it would be best to reference them by name or if there is another way. Name should work, however.
Here is the code I'm using to loop through the filters:
Thanks for any help!Please Login or Register to view this content.
Bookmarks