How to get slicer 2 to copy selection in slicer 1

[XcelGirl]

Hi Mr Excel community,

Hoping someone can help, never done this before so please bear with me.

I currently have 2 matching Slicers over 2 separate pivot tables with 2 data sets. I' m very new to writing VBA code and I am hoping someone can help me write a piece of code so when I select a name from SM on pivot table 1, it selects the same name on SM 2.

My Slicers are called Revenue and Custody

Are there any other ways to do this rather than using VBA?

Thanks in advance