Controlling Filters

Hi Jeffrey

Thanks for getting in touch. For this, you will need to have good knowledge of all the controls on your PivotTables and embed them in IF structures.

The easiest thing to do is record yourself manipulating the PivotTables and noting the names and references that it records.

Then, you could use a control (or build another on a UserForm) and add an event, such as SheetPivotTableUpdate, to it that then manipulates those other Pivot controls.

Give that a try and let me know how you get on.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector