I am trying to build an interactive dashboard based on the value selected in the dropdown box. I have included a sample data file which contains two tabs.
Data and dashboard, by looking on the dashboard you will see how I want to display the data.
thanks for your help!
See attached: excelguru2306sample data.xlsx
I'm a bit cross, because after having spent significant time finding a solution for you I discover you've cross posted and have probably got a solution elsewhere; I feel I've wasted my time.
Some light reading: http://www.excelguru.ca/content.php?184
Cross posts:
http://forum.chandoo.org/threads/int...shboard.12877/
http://www.excelforum.com/excel-gene...filtering.html
If I'd known, I could have spent the time dealing with your "...I have another scenario that", but I'm out of time now.
Bookmarks