troubleshooting Question

Setting up a TOC / Index in Excel with absolute references

Avatar of Dot Glindemann
Dot GlindemannFlag for Australia asked on
GolangMicrosoft ExcelMicrosoft Office
7 Comments4 Solutions166 ViewsLast Modified:
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") I have attached the sample I have been working with. Any assistance would be greatly appreciated. Thanks Dot
Sample-Register.xlsx
ASKER CERTIFIED SOLUTION
Neil Fleming
Consultant and developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros