Dynamic hyperlink

[Nader_Shaker]

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

[#2]

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

[#3]

Thanks for your reply
Tomorrow I will check the file as Iam using a Mobil now, I will feed you back

[#4]

Greeting
I tired today but I couldn't get the point.