Hello,

I was wondering if it is possible to create a macro or use VBA to create the following:

When a filter is selected on a pivot table on one spreadsheet the same filter choice is automatically selected on multiple pivot tables on the same spreadsheet and other spreadsheets.

Hopefully that is clear. Any help would be greatly appreciated as I am a newbie to the macro/VBA game and am not sure of the potential.

Thank you!
Dina