Dynamic hyperlink

%3CLINGO-SUB%20id%3D%22lingo-sub-2146686%22%20slang%3D%22en-US%22%3EDynamic%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2146686%22%20slang%3D%22en-US%22%3EI%20need%20to%20create%20a%20dynamic%20hyperlink%20inside%20a%20cell%20it's%20reference%20is%20changable%3CBR%20%2F%3EExample%3CBR%20%2F%3EA1%20%3DG20%3CBR%20%2F%3EThe%20hyperlink%20will%20be%20in%20side%20cell%20A1%2C%20and%20the%20reference%20of%20A1%20formula%20is%20changeable%20which%20is%20G20%2C%20may%20be%20G30%20or.....%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2146686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2146987%22%20slang%3D%22de-DE%22%3ESubject%3A%20Dynamic%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2146987%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F971187%22%20target%3D%22_blank%22%3E%40Nader_Shaker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%3C%2FP%3E%3CP%3EThe%20hyperlink%20should%20be%20kept%20dynamic%20-%20relative%20to%20the%20path%20of%20the%20workbook.%3C%2FP%3E%3CP%3ESolutionFollowing%20formulas%3A%20a)%20%3D%20LEFT%20(CELL%20(%26amp%3B%20quot%3B%20filename%20%26amp%3B%20quot%20%3B%3B%20A1)%3B%20FIND%20(%26amp%3B%20quot%3B%20%5B%26amp%3B%20quot%20%3B%3B%20CELL%20(%26amp%3B%20quot%3B%20filename%20%26amp%3B%20quot%20%3B%3B%20A1))%20-%201)%20b)%20%3D%20HYPERLINK%20(A1%20%26amp%3B%20amp%3B%20%26amp%3B%20quot%3B%20test1.%20xls%20%26amp%3B%20quot%3B)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20file%20please%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESource%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.herber.de%2Fmailing%2FDynamischer_Hyperlink.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.herber.de%2Fmailing%2FDynamischer_Hyperlink.htm%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2147273%22%20slang%3D%22en-US%22%3EBetreff%3A%20Dynamic%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2147273%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20reply%3CBR%20%2F%3ETomorrow%20I%20will%20check%20the%20file%20as%20Iam%20using%20a%20Mobil%20now%2C%20I%20will%20feed%20you%20back%3C%2FLINGO-BODY%3E
New Contributor
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.....
3 Replies

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

Thanks for your reply
Tomorrow I will check the file as Iam using a Mobil now, I will feed you back
Greeting
I tired today but I couldn't get the point.