Ask Your Question

How to create a hyperlink with a cell ref in the middle

asked 2018-12-01 22:45:03 +0200

RickHill gravatar image

I am trying to create a link that changes with the date entered in C1

Original Link ='file:///C:/2018Document.ods'#$heet1.A1 Attempted Link ='file:///C:/' & C1 & 'Document.ods'#$heet1.A1 but that is converted to ='file:///C:' & C1 & 'file:///C:Document.ods'#$Sheet1.A1 Any help is appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-01 22:58:39 +0200

Lupp gravatar image

updated 2018-12-01 23:01:46 +0200

A reference is not the string it is represented by. If you have concatenated the string you need to apply the function INDIRECT() to convert it to the reference.
In addition: string constants you want to calculate with need to be marked by doublequotes.
Try =INDIRECT("'file:///C:/" & C1 & "Document.ods'#$heet1.A1").

edit flag offensive delete link more


Thank you, Lupp! That is exactly what I was looking for. I had seen the Indirect Function but did not associate it properly. I will need to read more. Thank you again.

RickHill gravatar imageRickHill ( 2018-12-04 00:27:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-01 22:45:03 +0200

Seen: 27 times

Last updated: Dec 01 '18