VBA, Worksheet Change:

When values are added to Sheet1 Column A, also insert hyperlink on Sheet2 Column B that link back to Sheet1's cell.

I've been teetering on the edge of victory for 24 hours, but I just can't quite debug it.

I've tried both manual and formula methods, but hitting brick walls.

Hyperlinks.Add Anchor:=Sheets("Received").Range(Target.Offset(0, 1).Address), _
            Address:="", SubAddress:= _
            "Data!" & Target.Address, TextToDisplay:=Target
Sheets("Received").Range(Target.Offset(0, 1).Address) = "=HYPERLINK(""#Data!" & Target.Address & """,""" & Target & """)"
https://www.excelforum.com/showthread.php?t=994673