Hi,

In a big sheet of mine I have put a kind of table of contents at the beginning with a lot of hyperlinks that reference some cells in the sheet for easy navigation (the sheet has more than 3000 rows).

To do that I have named some cells and then linked the hyperlink to that names so that if the target cell is moved (say I add some lines on top of it) the link still works properly.

The problem is that when I copy the sheet and have another one identical then in this new sheet the table of contents still reference to the original sheet. Is there a way to quickly change the references of the hyerlinks so that they pont to their sheet and not the original one ?

The names that are referenced by the hyperlinks are all locals (not global)

Thanks for any suggestion

Paolo