Hello, I need some code that does the following with the triggers listed. I wrote my idea of what the code might look like. Thanks.
1. The user selects a record from a Slicer
2. The user clicks an ActiveX Button to navigate to another sheet within the workbook.
1. The sheet automatically filters the data to show only the records which apply to the value which the user selected from the Slicer.
.SlicerItems("WHATEVER THE USER CHOSE").Selected = True
utoFilter Field:=3, Criteria1:= _
"WHATEVER THE USER CHOSE"