Forum Discussion
Dynamic hyperlink
I need to create a dynamic hyperlink inside a cell it's reference is changable
Example
A1 =G20
The hyperlink will be in side cell A1, and the reference of A1 formula is changeable which is G20, may be G30 or.....
Example
A1 =G20
The hyperlink will be in side cell A1, and the reference of A1 formula is changeable which is G20, may be G30 or.....
3 Replies
Problem
The hyperlink should be kept dynamic - relative to the path of the workbook.
SolutionFollowing formulas: a) = LEFT (CELL (& quot; filename & quot ;; A1); FIND (& quot; [& quot ;; CELL (& quot; filename & quot ;; A1)) - 1) b) = HYPERLINK (A1 & amp; & quot; test1. xls & quot;)
See the file please
Source: https://www.herber.de/mailing/Dynamischer_Hyperlink.htm
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- Greeting
I tired today but I couldn't get the point. - Thanks for your reply
Tomorrow I will check the file as Iam using a Mobil now, I will feed you back
