Forum Discussion
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...
=HYPERLINK("#Help!" & ADRESS(LINE();2); "Help")
Work also well because it doesn't work with a fixed line number but a dynamic one so it solve the problem of adding new lines. The only thong I don't manage to do is pointing not only to 1 cell but the entire row (to higlight the entire row and make it more easy to spot for the user)
Thanks !
Work also well because it doesn't work with a fixed line number but a dynamic one so it solve the problem of adding new lines. The only thong I don't manage to do is pointing not only to 1 cell but the entire row (to higlight the entire row and make it more easy to spot for the user)
Thanks !
Arthur196 You can do that as well:
=HYPERLINK("#'Help'!"&ROW()&":"&ROW(),"Help")
