Hello

I have 3 pivot tables on one spreadsheet, when i choose an option in the first pivot table, i want all the other 2 pivot tables to automatically copy what i chose in the first pivot table.

see screenshot where first pivot table starts at row 303, i select email, my next pivot table which would be in row 403 should have the same option selected (email) and so on


can a macros do this? the rows the pivot tables in are always static and list of choices are also static

logic: if pivot table in row 303 = some option, then pivot table in rows 403 and 503 = this option in 303