Hello Excel-Community,
I hope there is anybody who can help with the following issue. I want to show in a dashboard certain data with a scrollbar. This data shall be filtered (see cell C3 and C4 in the attachment). With the scrollbar I only want to display 10 rows and more via scrolling down. Unfortunately, my filter function doesnt show the correct data and I dont know how combine filter function with a scrollbar.
Any better solution is also welcome.
Many thanks
Marcel
Please see attached. I've applied a technique to your file as described in Mynda's blog
https://www.myonlinetraininghub.com/excel-scroll-sort-table
Note that I had to fill in some data in the Status column as the all contained references to a local file and all returned #REF!. See if you get it to work in your real file and come back here in case you get stuck.
Many thanks Riny! I try it out and would come back to you if I need more help.
