Mar 30 2023 04:36 AM
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 (about 400 lines)
1 with help about the parameters
Both sheets has the same architecture : if parameter x is on line 15, help about x is also on line 15 in the help sheet.
I have hyperlink next to each parmeter to jump to the correct help in the help sheet that work with cell adress.
Problem is : if I add a new parameter (and so a new help line) it change all the adress (+1 on each line number) and so all the Hyperlink went wrong.
So I'm looking for a solution where I can give each Help line a tag that do not depends on the line number or column number so I can make an Hyperlink to the tag and not to the adress.
Thank you all in advance
Mar 30 2023 04:50 AM
Mar 30 2023 06:05 AM
Mar 30 2023 06:38 AM
Mar 30 2023 07:36 AM
@Arthur196 You can do that as well:
=HYPERLINK("#'Help'!"&ROW()&":"&ROW(),"Help")