Hi - I have a workbook with 51 tabs, 50 named after a state and 1 other. I have a drop down with each of the states on sheet1. How do i use the values in that drop down to reference one of the worksheets? Each of the state sheets would be the same, they would just have different data. I have code that will pull the data from the State sheet and put it in Sheet1. I guess I could have 50 macros, but I'm assuming there is a way to use the drop down value to reference a sheet.
So, set wsSTATE = Thisworkbook.sheets("Drop down Value Here")
Thanks.
So, set wsSTATE = Thisworkbook.sheets("Drop down Value Here")
Thanks.