In Excel I have two columns say ID and Link both are text
I have used the below macro.

```
Sub HyperAdd()

    'Converts each text hyperlink selected into a working hyperlink

    For Each xCell In Selection
        ActiveSheet.Hyperlinks.Add Anchor:=xCell, Address:=xCell.Formula
    Next xCell

End Sub

```

But the above macro makes current seletion cells with address same as its cell value.

So How do I get link in "ID" column with hyperling address details coming from column "Link"