XL2002 - PivotTable 2 to Match Pivot Table 1
 

Hi All

I have two pivot tables that are pretty much identical other than pivot2 has
2 less fields. What I need to do is programmatically update Pivot2 to match
the selected field items in Pivot1.
The pivot tables are on separate sheets.

Any help gratefully approciated.

Trevor Williams