Click on a cell and go to other cell in other Sheet, is possible?

[jamiguel77]

hi all friends....

i know how to create a Hyperlink and go to other cell in other sheet.

but the problem is the name of the hyper link is static.....

my cell have a Quantity... and it change constantly..

i make a Dashboard panel, i want user click (sample) on cell C5 with cell value: 5,980,000 (for know detail, and the detail exist on other sheet)

How to do? is possible?

thanks

 

[jamiguel77]

of course without VBA.

Thanks

 

[jamiguel77]

Done/Solved: https://www.mrexcel.com/forum/excel-questions/495225-dynamic-hyperlink-based-cell-value.html

Thanks

 

[jamiguel77]

here my formula:

=HIPERVINCULO(EXTRAE(CELDA("FileName",A1),ENCONTRAR("[",CELDA("FileName",A1)),255)&"'EQ TRANS'!BG89","LINK")

and excel acepted, not understand why when click on it say invlid reference, of course EQ TRANS sheet exists.

thanks