Forum Discussion
Arthur196
Mar 30, 2023Copper Contributor
Link to cell content and not adress
Hi evryone, I'd like to make hyperlinks that do not work with adress of the cell but with its content. Few explanations why : In the same workbook I have 2 sheets : 1 with parameters...
JKPieterse
Mar 30, 2023Silver Contributor
Use this formula to link to the same cell on the Help sheet: =HYPERLINK("#'Help'!"&CELL("address",A1),"Help")
Arthur196
Mar 30, 2023Copper Contributor
Thanks Jan it seems to be working good !