Forum Discussion

justa-user's avatar
justa-user
Copper Contributor
Dec 29, 2020

Excel hyperlink embed a cell reference

I am using WIN10 Office 365.   I have a hyperlink as shown.   E:\Date Files + Antarctica\aaaascantest\kw00575.jpg   The hyperlink is in cell k3 and works ok, but I have to create a new link or ...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Dec 29, 2020

justa-user 

 

Enter the following formula in K3:

 

=HYPERLINK("E:\Date Files + Antarctica\aaaascantest\"&H3&".jpg")

 

and fill down.

  • justa-user's avatar
    justa-user
    Copper Contributor
    Dec 30, 2020

    HansVogelaar 

     

    Just what I needed... Does the job   Thank you

Resources