Good day,
I have been searching for a solution to applying a filter to multiple pivot tables without using VBA.
The scenario is that I would have the user select the filter on a pivot table on Sheet1, and then subsequent sheets would have their filter set to the same value.
Is this possible without VBA? If so, how?
Thanks in advance.
I have been searching for a solution to applying a filter to multiple pivot tables without using VBA.
The scenario is that I would have the user select the filter on a pivot table on Sheet1, and then subsequent sheets would have their filter set to the same value.
Is this possible without VBA? If so, how?
Thanks in advance.