Help required to Jump from one cell to another with reference from the third cell

[js376]

I require urgent help. Can anyone please help me for the following problem:
I have an excel sheet for data entry (month wise)
it has 5 columns per day. and 150 products
so it is tiring to scroll every time to reach a particular date.
thus can anyone help me with a simple formula so that i directly jump to a specific date ( cell ) when i type a date in say A1.
example, i type in cell A1 "13" so i should directly go to cell CF15 ( where the date 13 is)

 

[Joe4]

You can do what you want with Worksheet_Change event procedure code, with is VBA code that is automatically triggered whenever a specific cell is updated on your sheet.

Just right click on your worksheet tab name at the bottom of the screen, select "View Code" and paste the following VBA code in the resulting VB Editor window:

Private Sub Worksheet_Change(ByVal Target As Range)


    Dim mySearchValue As Variant


'   Check to see if cell A1 was changed
    If Target.Address = Range("A1").Address Then
'       If so, capture the value
        mySearchValue = Target
'       And search for it
        Cells.Find(What:=mySearchValue, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
            xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
            , SearchFormat:=False).Activate
    End If


End Sub

It will jump to the cell with that value. If it cannot find the value, it will stay in cell A1.