Hyperlink to a cell based on the data in the cell, not the cell reference itself

[billyshears]

WorkSheet 1

Cell B1 = Happy



WorkSheet 2
A1 = Happy B1= Green C1 = Red

Can I have a hyperlink in cell A1 on Worksheet 1 that hyperlinks to Cell A1 in worksheet 2 based on the fact I wrote "Happy" in Cell B1 on Worksheet 1

Thank you

 

[kennypete]

If you try this, adding code using "View Code" on Sheet1 as shown below:

...then add this code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B1")) Is Nothing Then
        If Target.Value = "Happy" Then
            Target.Hyperlinks.Add Anchor:=Cells(1, 1), Address:="", SubAddress:="Sheet2!A1", TextToDisplay:="Link"
        End If
    End If
End Sub

When you change Sheet1, cell B2 to Happy, it will enter "Link" into Sheet1 cell A1 and that link goes to Sheet2 cell A1...

 

[kennypete]

Hi @billyshears was this solution what you were after?