change pivot table in code
 

Hi,

Does anybody know some example code I can use for the following situation:

I have 2 pivot tables on a sheet which both have the same report filters. If
I change the filter selection on pivot table 1, I want (through code) for
pivot table 2 to automatically apply the same filter selection.

Hope u can help,

Thanks,

Basil