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...

excel

NikolinoDE

Platinum Contributor

Feb 18, 2021

Nader_Shaker

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.

Hyperlinks_Dynamisch.xls33 KB