I am trying to write a marco that allows me to have a list of names and find the correct worsksheet tab.
Let me be more specific.
I have created a drop down function that is connected to a list (The list being all the names of my worksheet tabs). I have then created a lookup function that shows the particular worksheet I would like to analyze. What I need is for the macro to recognize that name and open the correct worksheet.
This is my code so far. It is updating two queries, then brining me back to my home page. From there I want my drop down list which the cell link is m3. On cell m4 I have a vlookup which says the same (ex."Avg Daily Gain"). From there I would like my macro to take the cell link (m3 or if need the entire name m4) and open the same named worksheet.
I'm assuming that Criteria is the name of your 'home page' and that the cell Criteria!M4 contains a valid worksheet name. I'm also assuming that you want to select/activate the worksheet specified in Criteria!M4. If your 'home page' is named something else then you'll need to amend the string in red accordingly.