So, you’ve designed a great looking report or dashboard in Excel. But, wouldn’t it be great if you could add a small section of the report where the user could scroll through a filtered set of the raw data? Well, it’s funny you should ask…
Here we have some data I made earlier… a table of order data and a list of orders.
What we’re aiming to do is create a magical Scrolling Dynamic Lookup window to add to our equally awesome report, like so: