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

js376

New Member
Joined
Mar 11, 2014
Messages
3
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)
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,465
Office Version
365
Platform
Windows
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:
Code:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,261
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top