View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trevor Williams Trevor Williams is offline
external usenet poster
 
Posts: 181
Default 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