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.

Will the built in Data Filter suffice ?

https://support.office.com/en-us/art...6-27b932e186e0

If you use data validation you can use the Worksheet_Change event to run a macro based on the selection,
but somewhere you'd have to layout what the possible scenarios are.

Any chance of you attaching a sample workbook indicative of what you're working with and trying to achieve?

Obviously you get data from SQL Server with ODBC query. Let's assume the query is something like
You can have instead a query
When trying to run the query it will ask for 1st parameter, and then for 2nd parameter. You can point cells in Excel worksheet as sources for those parameters, and set the query to be executed whenever those cells will change.

On sheet where queried data appear, leave/insert some empty rows at top (at least the number of parameters +1). Define Data validations to select parameter values at top cells, and select some parameter values there. Now redefine your query like was shown before, and point cells with selected parameters when asked.