View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Pivot Table Page Change Code

Check out this link...

http://www.contextures.com/excelfiles.html#Pivot
--
HTH...

Jim Thomlinson


"PFLY" wrote:

I have two pivot tables on the same sheet, PivotTable1 and PivotTable2. What
is the code for changing the page value on the drop down box on one pivot
table so the second pivot will automatically change as well?