Excel hyperlink embed a cell reference

%3CLINGO-SUB%20id%3D%22lingo-sub-2021046%22%20slang%3D%22en-US%22%3EExcel%20hyperlink%20embed%20a%20cell%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2021046%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20WIN10%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20hyperlink%20as%20shown.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE%3A%5CDate%20Files%20%2B%20Antarctica%5Caaaascantest%5Ckw00575.jpg%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20hyperlink%20is%20in%20cell%20k3%20and%20works%20ok%2C%20but%20I%20have%20to%20create%20a%20new%20link%20or%20edit%20this%20one%20when%20I%20want%20to%20copy%20the%20link%20to%20a%20new%20row.%26nbsp%3B%20The%20data%20%22kw00575%22%20is%20in%20a%20cell%20on%20the%20same%20line%20as%20the%20hyperlink%20(it's%20in%20h3).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20hyperlink%20that%20includes%20the%20data%20in%20a%20cell%20in%20the%20current%20sheet.%20For%20example%3A%26nbsp%3B%20E%3A%5CDate%20Files%20%2B%20Antarctica%5Caaaascantest%5Cxxxxxx.jpg%20where%20xxxxxx%20is%20the%20data%20in%20a%20cell%2C%20say%20h3.%26nbsp%3B%20I%20want%20to%20create%20the%20link%20and%20then%20be%20able%20to%20copy%20the%20link%20so%20that%20the%20cell%20reference%20changes%20appropriately.%3C%2FP%3E%3CP%3Ei.e.%20if%20xxxxxx%20was%20in%20cell%20h3%20and%20the%20link%20was%20in%20cell%20k3%2C%26nbsp%3B%20I%20would%20like%20to%20copy%20the%20link%20to%20cell%20k4%20and%20have%20the%20reference%20change%20to%20h4.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20have%20over%203000%20lines%20in%20the%20sheet%20and%20I%20do%20not%20want%20to%20have%20to%20create%20the%20hyperlink%20for%20each%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2021046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2021298%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20hyperlink%20embed%20a%20cell%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2021298%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F913748%22%20target%3D%22_blank%22%3E%40justa-user%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20K3%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DHYPERLINK(%22E%3A%5CDate%20Files%20%2B%20Antarctica%5Caaaascantest%5C%22%26amp%3BH3%26amp%3B%22.jpg%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%20fill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 edit this one when I want to copy the link to a new row.  The data "kw00575" is in a cell on the same line as the hyperlink (it's in h3).

 

I would like to create a hyperlink that includes the data in a cell in the current sheet. For example:  E:\Date Files + Antarctica\aaaascantest\xxxxxx.jpg where xxxxxx is the data in a cell, say h3.  I want to create the link and then be able to copy the link so that the cell reference changes appropriately.

i.e. if xxxxxx was in cell h3 and the link was in cell k3,  I would like to copy the link to cell k4 and have the reference change to h4.

 

I will have over 3000 lines in the sheet and I do not want to have to create the hyperlink for each line.

 

Thanks for the help.

2 Replies

@justa-user 

 

Enter the following formula in K3:

 

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

 

and fill down.

@Hans Vogelaar 

 

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