User Control

[ksikor14]

I desperately need help. I have an Excel Spreadsheet on the Data Tab I am pulling in all the data from a SQL Table. On the First Tab I have pulled out all the columns I want to pull in from the data tab. However I need to make a list box or control or something that allows the user to select a scenario and then all the data associated with that scenario on the Data Tab gets pulled in. Please someone I can't make this work I can add the Data to the data tab with all of the scenarios in it. I just can't figure out how the user can select the scenario on Tab 1 and then all the data gets populated to the appropriate columns. I tried list but don't know how to focus I tried scenario manager or data validation but I have 40 columns and 30 rows that need to be pulled in after the scenario is chosen.



Any help or suggestion would be greatly appreciated.