I haven't updated Pivot Tables with multiple values like you're requesting, but here is an example where the filter on every pivot table in a workbook is reset to a new value on a master sheet.
This example only loops through five sheets (the 2nd through 6th) and that loop code will need to be changed to follow your workbook construction.
Yes for instance in May and May entries, you want to set the filter to October to April.
(Information period is October - September for instance.
, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence.
Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports. Start your free month on Linked In Learning, which now features 100% of courses.
Any time you close then re-open the file, the pivot table will be refreshed.
To set this up: The final way to update the pivot table is with programming.
I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.
When you change the grouping in one pivot table, the same grouping appears in the other pivot table.
For example, change the date grouping in the first pivot table to Months, and the dates in the second pivot table automatically group in Months.
Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
You'll definitely want a VBA routine to do something like this.