VBA to Change Filter in Multiple Pivot Tables based on A Cell Value

This Excel VBA Tutorial explains VBA Code to Apply Filter in Multiple Pivot Tables. We can use drop down list from a Cell as Filter for multiple pivot tables. VBA Code will loop through all pivot tables on the sheet and change value in filter as per selected value.
Website :- WWW.EXCELDESTINATION.COM

[HenryYWH]

Out of all the sites I checked, this is the only one that worked. Thanks!

[sirajkhan]

Works for me, thank you so much, with loads of love.

[CesarLlanosBaron]

Awesome!!! thank you very much, Im going to try it right now... I have 14 Pivot Tables in one Sheet!!!!

[kissxk]

Hi, thanks for this. is the command any different for a powerpivot table where the source is the datamodel? thanks

[robhermany]

You have great videos. Thank you for all of your help! Similar to your form video where you update the source data with a "Search and Display button", how would you update multiple pivot tables and slicers/upon entering in an opp_ID into a textbox form? In other words, instead of changing a filter in multiple pivot tables based on a cell value, it would be to change filter in multiple pivot tables based on a VBA form input / text box?

[sarano]

Thanks so much, great video. Is there a way to set all Pivot tables to refresh immediately (without having to click that Refresh button) when a cell value at dropdown list changes?

[ganesha]

How to protect worksheet while using dropdown list for pivot tables?

[ganesha]

May i know, how to work on different worksheet pivot tables?

[joramandrew]

This is great and very helpful however does this code work for pivot tables connected using data model.?

[luirm]

Hi boss, is there any way you can share the code with multiple pivot fields selected

[ahmadaltayeb]

Sir, this code give me run time error 1004, and mark on line (.CurrentPage=a), i use office 2019 and 2021, please advice

[sahilkumar-iwor]

@Excel Destination : Sir, if in the same case we have multiple cities in the data, like 1 row is delhi, Mumbai Other row is Delhi, other is Delhi, Pune. For this data how can we use the VBA? (like in excel we use logic in pivot ''CONTAINS'' Delhi)

[firozbaigmogal]

good morning sir
Awesome!!! thank you very much
how to create the button pls tell me

[mimiten]

How to change multiple table with different city values?

[euridiceferreira]

Good morning Sir. This a very important example. How would you modify the code if the pivot tables were in different sheets within the same workbook? Appreciate your response. Thank you.

[mumbai]

Hello everyone, need your help if anyone can share some input

I need to select 10 items in fieldname which are available in sheet 1 using vba. What code can be used?

[adrianobrito]

Hi! tks for the explanation.. how can I change the code to include 2 more cells with dropdown for the filter?

[jaimecastellanos]

This was amazing! But Im having issues on the .currentpage=a / Run-time error '1004': Unable to set the CurrentPage property of the PivotField Class. How could I fix it sir? Thank you

[victoriardgs]

Hi there, I have tried this but it only works on sheets where my pivot tables are next to each other. Any way to slightly adapt this for pivot tables underneath each other ? Thanks !

[heng]

May i know How do we change the filter based on just another cell value instead of clicking the button?