chriswhincup
New Member
- Joined
- Apr 19, 2023
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Hi,
I have a dashboard that I want to be able to display data from a number of pivot tables on one sheet and I currently use a slicer for the salesperson with a drop down filter to choose the sales person. This works fine but I only actually need to display data for a smaller team of 6 rather than the 2000 that are there so would like to make it easier for other people to navigate. Is there a way to display button with the names on and for this to choose from the filter. I tried to record a macro for each button but it just keeps erroring when I run it.
I have a dashboard that I want to be able to display data from a number of pivot tables on one sheet and I currently use a slicer for the salesperson with a drop down filter to choose the sales person. This works fine but I only actually need to display data for a smaller team of 6 rather than the 2000 that are there so would like to make it easier for other people to navigate. Is there a way to display button with the names on and for this to choose from the filter. I tried to record a macro for each button but it just keeps erroring when I run it.