Use dropdown to jump to specific cell on worksheet

[pyclen]

Hi there,

I have a worksheet, example shown below.
In cell B3 (based on a range in b42:b46) I want to select a Stab (Stab 1 - 4) and upon selection the cursor jumps to the corresponding cells (B14, O14, AB14, AN14).

I know others have asked the same or similar questions however since most of it is VBA which I am not familiar with I am having a hard time to adjust whatever code to my needs.
The sheet below is an example and the real deal is a bit larger but below is a good representation of what I am trying to achieve.

I found a solution that uses the Address function w/index&match however it is for a vertical list of values and not like mine w/values arranged horizontally and separated by a number of columns

I am thankful for any help and/or suggestion that can solve this for me.

 

[davesexcel]

You can use find to get to the correct cell.
Placed in the worksheet module.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$3" Then
        If Target.Value <> "" Then
            Range("A14:AW14").Find(what:=Target.Value).Select
        End If
    End If
End Sub

 

[pyclen]

You can use find to get to the correct cell.
Placed in the worksheet module.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$3" Then
        If Target.Value <> "" Then
            Range("A14:AW14").Find(what:=Target.Value).Select
        End If
    End If
End Sub

Great, that does the trick, now I need to update for the real sheet but I am sure I figure this out.

Thanks again for the help