ExcelBanter - Pivot Table Page Change Code

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Page Change Code (https://www.excelbanter.com/excel-discussion-misc-queries/187645-pivot-table-page-change-code.html)

PFLY

Pivot Table Page Change Code

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?

Jim Thomlinson

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?

All times are GMT +1. The time now is 07:12 PM.