In column D I have a list of numbers "111112"
I would like to turn those numbers into hyperlinks I want to show the original number but the hyperlink website would be http://ph/l.aspx?d=. (cell number) I have tried using the
=hyperlink("://ph/l.aspx?d="&d2,d2)
but the website is not updating correctly.
Any help would be great, also if able to do it in vba so I wouldn't need a extra column would be even better
I would like to turn those numbers into hyperlinks I want to show the original number but the hyperlink website would be http://ph/l.aspx?d=. (cell number) I have tried using the
=hyperlink("://ph/l.aspx?d="&d2,d2)
but the website is not updating correctly.
Any help would be great, also if able to do it in vba so I wouldn't need a extra column would be even better