Filter Pivot Table Based on Cell Value

[cp41]

Hello,

I am looking to change the filter of a pivot table based on the cell value in a different sheet. I want to change the Model filter in the 'PivotSheet' based on the value of A2 of the 'Filter' sheet. That is, if cell value of 'Filter!'A2 is 2, then the pivot table on Pivot sheet would filter on Model 2.

I appreciate any help!

[AlphaFrog]

Try something like this. The code goes in the Filter sheet's code module.

• Right-click on the Filter tab and select View Code from the pop-up context menu
• Paste the code in the worksheet's code module.

Please Login or Register  to view this content.

[cp41]

Works great! Thank you!

[georgekmathew]

I am looking to Control Pivot Table Filters by using a Combo Box in Excel 2007, Please help

Thank,

George