find the content of a cell in another sheet based on the content of a cell

Jos1972

New Member
Joined
Nov 3, 2008
Messages
33
Hello,
I'm looking for a macro to jump to a cell in sheet 2 based on the content of a cell in sheet 1.

Basically what the macro should do is:
Find cell A1 of sheet 1 in column B of sheet 2 and go to that cell.

I've looked for a solution but couldn't find it. Hope it is a simple question?
Thanks,
Jos
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,261
Office Version
365
Platform
Windows
How about
Code:
Sub Jos1972()
    Dim Fnd As Range
    Sheets("Sheet2").Activate
    Set Fnd = Range("B:B").Find(Sheets("Sheet1").Range("A1").Value, , , xlWhole, , , False, , False)
    If Not Fnd Is Nothing Then Fnd.Activate
End Sub
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,261
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,100,140
Messages
5,472,751
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top