How to jump to a cell based on a number in another cell

[asivaraman]

I have a project tracking sheet.

I need to jump to a cell based on the number i fill in another cell.
I have attached an image for visual reference.
When I type number "2" in F5, i need the cell to jump to R5 (i.e Oct-30)

I may create up to 52 weeks so the formula should work accordingly.

Please help. or suggest another easier way?
Thank you

 

[My Aswer Is This]

Actually I can write it better like this:

Private Sub Worksheet_Change(ByVal Target As Range)

'Modified  10/19/2020  1:01:13 AM  EDT
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub

If Target.Column = 6 And Target.Row > 4 Then

    Select Case Target.Value

        Case 1 To 10: Target(, Target - 1 * 5 + 13).Select

    End Select

End If

End Sub