VBA Macro to Filter Pivot Tables

[excelforumkeys]

Hello,

I'm working on building a "before and after" business scenario modeler in Excel 2010. I have the initial model set up and it uses about 40 simple pivot tables in 5 worksheets to populate the before and after results in a separate summary sheet.

Currently I have it at an "all up" countrywide view. What I'd like to due is introduce a specific forms each with checklist options that mirror possible filter options (e.g. state, region, etc.) that when selected will apply those filters to ALL the pivot tables in ALL 5 worksheets with the push of a "refresh" button.

I've seen some posts that lead me to believe this is possible and shouldn't be a major effort. Any help would be great appreciated to get me started!

Thanks much!

Chris

[dinesh_ltjd]

you can use the Slicer function and connect all the pivots to slicer...