Hello Great Gurus of Excel,
I've recently been trying to develop a spreadsheet where the values of the data table and graph change based on what is selected on the drop-down filter. To provide more detail about this I have a tab called "Raw" that has the set of raw data. Then on the "data" tab is where the most important information lies along with corresponding graphs for the data and on the third tab there is the "lookup" where I was using this as part of the data validation. I'm having trouble trying to use the information on the "lookup" table to present the relevant data. The goal would be for the user to select the region and it would update with all the proper information dynamically. Any help with trying to solve this would be greatly appreciated.
Thank you for your time in advance!
Bookmarks