Change pivot item filter to same filter for multiple pivot tables on one sheet

[David Schaleger]

I'd like to use VBA to change all of the pivot table report filters for several pivot tables on one sheet to the same single filter criteria (Excel 2007).

I have several pivot tables on one sheet. Each one reports on data from a different sheet in the same workbook. Each pivot table uses the same year-month filter in a YYYY.MM (numbers) format. Thus, I view several different pivot tables on one sheet, each reporting a different data set for the same year-month.

I envision the code working by clicking a button on the pivot table worksheet, being prompted for the YYYY.MM that I want to filter for, and then the code refreshing the source data before looping through all of the pivot tables on this sheet and changing the filter to the entered YYYY.MM.

Thanks for any suggestions.