Hyperlink in one excel sheet to other sheet

[shanck]

Hi All,

Could someone please help me in getting a solution to this.

I have 2 sheets in excel file. If I click on a cell in sheet 1 , it should redirect me to same cell of other sheet. I have values in almost 200 cells. How do I do that without manually making it hyperlink and editing each one.

Thanks,
Shanck

[FDibbins]

The HL is fairly simple, but why would you want to link in the 1st place?

[excelfandoo]

Try below code. Please change sheet names, row and column number as per your requirements.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column >= 1 And Target.Column <= 10 Then
        If Target.Row >= 1 And Target.Row <= 200 Then
            ThisWorkbook.Worksheets("Sheet2").Activate
            ThisWorkbook.Worksheets("Sheet2").Cells(Target.Row, Target.Column).Select
        End If
    End If
End Sub