Xiaorong has attended:
Excel Intermediate course
Excel Advanced course
Macro for Dashboard Slicer
Hi Jens
You have helped to set up a macro to clear filter for slicers 1, 2, 3 in Dashboard.
I copied and pasted for slicer 4 on the same dashboard. It worked to clear slicer 4.
But I can't edit to:
make first macro to control only slicer 1, 2 and 3 relating to table 1.
and 2nd macro only to control slicer 4 relating to table 2.
Could you please help.
Thanks in advance.
Xiaorong
RE: Macro for Dashboard Slicer
Hi Xiaorong,
Thank you for the forum question.
Please find attached word doc with the help.
Kind regards
Jens Bonde
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