Hi,
I'm not too sure if this is possible to do in VBA. I currently have multiple pivot tables on a single worksheet. I'd like to be able to have a single filter that filters all the pivot tables, as opposed to separate filters per pivot table. The pivot tables are identical except for the calculation. For example, one is calculating the count and the other the sum (see the attached workbook).
I know I could probably use Slicers to do this. However, I'd like to avoid this as I prefer the filter to drop down.
I've attached an example of my problem. As you can see, there is a filter for each pivot table. I'd like to only have one filter for both pivot tables.
Any help would be appreciated.
Thanks
Pivot Table Example.xlsx
Bookmarks