Hi, I am looking to create a drop down list that when I choose a value it will take me to a certain cell in the same sheet.
For example the sheet I'm working on has building floors:
Block A, Ground Floor, Level 1, Level 2, Level 3,
Block B, Basement, Ground Floor, Level 1, Level 2, Level 3
Each new level in my sheet has it's own defined name, meaning Block A -> Level 1 is called aLevel1, Block B -> Ground Floor is called bGF, etc
I need to create a drop down menu of all the levels as there is too many to list along the excel sheet. So that the user can easily choose a level from the list, then be directed to the corresponding cell on the same sheet. Even if I can only do one drop down list per block that is fine, as in Block A has it's own drop down list, Block B a different one, etc...
I am fine with trying to create macros and whatever anyone thinks will help me.
Bookmarks