Greengoblin123
New Member
- Joined
- Nov 3, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hi there,
I would like to know how to link a scroll bar to the filter in a pivot table in such a way that each time I increase or decrease the Scroll bar it increases or decreases the filter on my pivot table. Eg: increasing the scroll bar changes the year from 2013 to 2014. I know I could use a slicer instead but I have been tasked with using a Scroll bar instead. Any help on this would be greatly appreciated, thank you.
I would like to know how to link a scroll bar to the filter in a pivot table in such a way that each time I increase or decrease the Scroll bar it increases or decreases the filter on my pivot table. Eg: increasing the scroll bar changes the year from 2013 to 2014. I know I could use a slicer instead but I have been tasked with using a Scroll bar instead. Any help on this would be greatly appreciated, thank you.