Hi All

I was wondering whether someone can help me with a VBA code.

What I need to do is to go to a worksheet once a slicer value from my pivot table is selcted.

I have a league table odf sales in a Pivot table which is ranked by Salesperson.

I have created a from sheet so when a division is selected from a slicer the Pivot table in Sales Worksheet will show the sales person for the selected division and their ranking.

My front sheet is called Selector and my slicer value is Slicer_Division

What I need is everytime a selection is made from the slicer then it goes to worksheet sales.

Any help is appreciate it