Hello,
In Cell A1 I have a filepath such as:
E:\MyFolder\Doc.pdf
E-drive is a Thumb Drive
This filepath is created with:
CONCATENATE(LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1), "Doc.pdf")
I am trying to have a Formula in A2 which would Hyperlink cell A2 to the address in A1.
The purpose is that if I copy MyFolder to another drive, say C, than in A1 I will get
C:\MyFolder\Doc.pdf
But now I want the Hyperlink to relate to the same doc but on C drive;
A kind of “dynamic link”
Is this possible?
Thanks