Excel Dropdown List to jump to a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2705023%22%20slang%3D%22en-US%22%3EExcel%20Dropdown%20List%20to%20jump%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2705023%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI'm%20imagine%20this%20must%20have%20been%20asked%20countless%20times%20but%20I%20couldn't%20find%20a%20solution%20to%20my%20specific%20needs.%20So%20I'm%20asking%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%20to%20do%3A%20I've%20got%20a%20drop-down%20list%20created%20with%20data%20validation.%20When%20I%20select%20a%20value%20from%20that%20list%26nbsp%3B%20I%20want%20excel%20to%20jump%20to%20that%20specific%20cell%2C%20in%20the%20same%20sheet.%20I%20don't%20need%20to%20work%20with%20different%20sheets.%20The%20sheet%20is%20named%20John%20Doe%20for%20argument's%20sake.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20drop-down%20list%20is%20in%20A22%20my%20first%20value%20is%20in%20B90.%20How%20would%20I%20go%20about%20doing%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20googled%20quite%20a%20bit%20and%20it%20seems%20I%20need%20to%20create%20a%20macro%20in%20order%20to%20do%20this%20however%20I'm%20only%20a%20beginner%20in%20excel%2C%20I'm%20taking%20a%20course%20right%20now%20but%20I%20have%20not%20yet%20arrived%20at%20macros.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20your%20help%20would%20be%20most%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2705023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2705205%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dropdown%20List%20to%20jump%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2705205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1142876%22%20target%3D%22_blank%22%3E%40kheldar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20don't%20need%20vba%20to%20do%20that.%3C%2FP%3E%3CP%3EFind%20attached%26nbsp%3Bexample%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

 

What I need to do: I've got a drop-down list created with data validation. When I select a value from that list  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.

 

My drop-down list is in A22 my first value is in B90. How would I go about doing that?

 

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.

 

So your help would be most appreciated.

 

Thanks.

1 Reply

@kheldar 

 

you don't need vba to do that.

Find attached example