Link if certain text is entered

[cagni]

Hi All

Looking for a macro that can copy the link from a certain cell if YES is entered in another cell.

For example in F10 we have text "Link" with a link that links to a pdf in a certain folder. I want a macro that takes this link and add to any cell in column F only if text YES is entered. Then make the "YES" as a link as well with the link from F10.

This will be the same for G10, H10, I10, J10 and so on.

If this possible at all.

 

[cagni]

Can also be that it doesn´t have to copy the link from cell F10 but just use certain link for that specific row.

 

[cagni]

I have worked a little on this and have found this code and worked a little with it. Would it be possible to apply to this code that it has to take the link from f.eks. F5 which is an active link?

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rangeLimit As Range

Set rangeLimit = Range("F10:F1999")

If Not Intersect(rangeLimit, Target) Is Nothing Then
If Target = "YES" Then
Target.Hyperlinks.Add Anchor:=Target, Address:="LINK", SubAddress:="Sheet2!A1", TextToDisplay:=Target.Value
End If
End If
End Sub