Interactive Dashboard Functionality

[marcelkahn5]

Hi Excel Forum!

Is there any way we can make a dashboard like Itunes: So ideally there would be a column for selection options and everything on the right columns would change based on the selection (all of this happening on the same worksheet). Thank you for all the help!

-MK

[FDibbins]

You could probably do this with a Drop Down list (using Data Validation)

For further assistance, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[marcelkahn5]

Here's a quick sample of what i'm trying to do.

Thanks!

-MK

[FDibbins]

See if the attached will get you started. I created a small table off to teh right with each selection's list, and then used INDEX/MATCH to pull out the items based on what is entered into A1.