Multiple Pivots One Filter

[HELL DRAGON]

Hello all ,


I have one workbook that has multiple sheets (around 18 sheets)
each sheet has a pivot table
is it possible to make all 18 pivot tables filters by one button only ?

coz it's such a pain to filter each sheet specially if im planning to have 20+ sheets in one workbook.

if its not possible then any better ideas ?

 

[Zakkaroo]

Had this saved in my History. Scroll down to the very bottom.

http://www.mrexcel.com/archive/Pivot/14533.html

Worked perfectly for me, you just have to have the specific cell selected, the one that you want to be the same across all pivot tables and then run the Macro

 

[HELL DRAGON]

Had this saved in my History. Scroll down to the very bottom.

http://www.mrexcel.com/archive/Pivot/14533.html

Worked perfectly for me, you just have to have the specific cell selected, the one that you want to be the same across all pivot tables and then run the Macro

Thanks alot man looks promising , i will try it and let you know if it works

Thanks again mate , hope it works