Log In
Register
Home
Active Member
June 21, 2024
Offline
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
See Answer
Moderators
January 31, 2022
Offline
Please see attached. I've applied a technique to your file as described in Mynda's blog
https://www.myonlinetraininghu.....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.
Answers Post
1 Guest(s)
