Moving around the screen

[sadavies2906]

Hi all
I have a data validation box in cell b2 with the following options, Q4-19, Q1-20, Q2-20.

Columns a:c are locked
data for Q4-19 starts in column d to p
data for Q1-20 starts in column q to ac
data for Q2-20 starts in column ad to ap

Based on the data validation selection I want the cursor/screen to move in the following way

Q4-19 go to d1
Q1-20 go to q1
Q2-20 go to ad1

can this be done with macros and just a formula of the back of the data validation selection?

Regards
Stephen

 

[Yongle]

Code goes in SHEET module
(right-click sheet tab \ viw code \ place code in window which open up)

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address(0, 0) = "B2" Then
        Select Case Target
            Case "Q4-19": [D1].Select
            Case "Q1-20": [Q1].Select
            Case "Q2-20": [AD1].Select
        End Select
    End If
End Sub

 

[sadavies2906]

Thank works great