How to add a search bar and search functionality to a scrollable table on a Microsoft Excel Dashboard
More than 2 years back my friend and Microsoft Excel MVP Chandoo gave me the opportunity to publish a series of 6 articles on how to implement interactive Microsoft Excel dashboards on his excellent blog Chandoo.org: KPI dashboards with Microsoft Excel. To my surprise these articles still seem to be very popular over at Chandoo.org and Chandoo’s readers even keep on commenting these posts.
Yesterday Milind raised an interesting question: Is it possible to add a search bar to the dashboard to look up values in the source data and automatically scroll up or down to the according row of the search result?
Although Hui already explained how to do this in a comment, I decided to elaborate a little bit on the possible options in this additional article here on Clearly and Simply. Today’s post describes 2 different techniques on how to add a search functionality to a dashboard with a scrollable data table. As always, including the Microsoft Excel workbooks for free download.