First Off I have a sql table that is being pulled into an Excel Document to a Data Tab. Then on the main spreadsheet I have about 40 columns of data about 50 rows. I created a List Box with Data Validation to allow the user to select a column called scenario, since scenario manager says I have too many columns currently I have 5 scenarios. If the user select's a scenario I want the data that is associated with that Scenario to Populate the Main Spreadsheet. I have been researching different post I want all of the rows and all of the columns associated with QTR1 Scenario, or Qtr2 Scenario etc. Hopefully I am asking this correctly. Tab 1 Main Spreadsheet, Tab 2 Data Tab. I just want a user control to allow the user to select which scenario they want which will automatically pull in all the data associated with that one Scenario and Populate the Main Sheet. Thanks

If anyone knows of a better way I am all for it.