Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Sheet1.Cells(Target.Row, Target.Column) <> "" Then
For i = 1 To Sheet2.UsedRange.Rows.Count
If Sheet2.Cells(i, 1).Value = Sheet1.Cells(Target.Row, Target.Column).Value Then
Sheet2.Activate
Sheet2.Range("A" & i).Select
End If
Next i
End If
End Sub