asked on Setting up a TOC / Index in Excel with absolute references
Hi, I am trying to set up an Index / Table of contents in an Excel File with fixed or absolute references. When I use the insert hyperlink function and fix my references using $ when I go back later they have disappeared. I have tried using contextures but while it works it does not have the option to rename it like you can with a hyperlink. I need the links to move when the cell moves when I add or delete rows etc. The link I have used is =HYPERLINK("#'"&E2&"'!D2")
Sample-Register.xlsx
Sample-Register.xlsx
GolangMicrosoft ExcelMicrosoft Office
Last Comment
Neil Fleming
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Are you doing this with the Go language?
ASKER
Thank You all for your comments and assistance with this problem. My spreadsheet is now working they way that I want it to and you have saved me a lot of frustration. Have a great day. Thanks Dot
Glad it was useful, Dot.