Excel Dropdown List to jump to a cell

Question

Hello,I'm imagine this must have been asked countless times but I couldn't find a solution to my specific needs. So I'm asking for your help.&nbsp;What I need to do: I've got a drop-down list created with data validation. When I select a value from that list&nbsp; I want excel to jump to that specific cell, in the same sheet. I don't need to work with different sheets. The sheet is named John Doe for argument's sake.&nbsp;My drop-down list is in A22 my first value is in B90. How would I go about doing that?&nbsp;I've googled quite a bit and it seems I need to create a macro in order to do this however I'm only a beginner in excel, I'm taking a course right now but I have not yet arrived at macros.&nbsp;So your help would be most appreciated.&nbsp;Thanks.

dcosmos · Answer

Juliano-Petrukio&nbsp;&nbsp;Hi! This is the solution, but I don't understand how you make different Hiperlinks on a dropdown list.

juliano-petrukio · Answer

kheldar&nbsp;&nbsp;you don't need vba to do that.Find attached&nbsp;example&nbsp;

abra345 · Answer

dcosmos&nbsp;Juliano-Petrukio&nbsp;can someone help me figure this out? How did you create this drop-down with links? i checked the file and i can't find out how you did it

eric1969 · Answer

Ok- now how did you do this? Giving an example doesn't really show the steps..

Forum Discussion

Excel Dropdown List to jump to a cell

Resources