(First post, yay!)

Hi, I'm trying to develop a 'dashboard' in Excel 2010 that allows a user to browse through a scrollable list of records, click on one, and have the corresponding numbers affect the displayed charts. Is there a way for such a scrollable list on worksheet to pull data from a separate worksheet (to populate itself), and have those rows be clickable?

I'm trying to replicate something I've seen in Xcelsius, since Xcelsius has considerable functionality issues, i.e. there are some very simple things it simply can't do.

Thanks,
-Andrew