I try to create a dynamic sheet controlled by a dropdown menu. I have managed to create what I am looking for, but I think my solution is bad. I would therefore like some feedback or an alternative solution (i rather not use VBA, because I have no experience with it.
This is how I built it:
1) I use a activeX combobox to create my dropdown, it fetch its data from a table.
2) After that i do a vlookup to get a "id" for that specific dropdown-choice.
3) I then use the INDIRECT function to search for a tab/sheet with a corresponding name and then print the information from A1.
4) I then repeat step 3 for A2,A3 etc.
/Pew
Bookmarks