change pivot filter through code
Hi,
I've posted before on this, but had no luck - annoying as I know it is
possible since I've done it myself in the past (but lost the file!).
I have 2 pivot tables on a sheet which both have the same report filters.
When I change the filter selection on pivot table 1, I want (assumingly
through code) for pivot table 2 to automatically apply the same report filter.
Hope u can help,
Thanks,
Basil
|