Summary of hyperlink info on spreadsheets

D

domdom8754

Hello,
I use several workbooks for detailing connections between pieces o
equipment.

There are many, many hyperlinks between the sheets. I find to tricky t
keep them all up to date.

I have seen there are programs available which summarise all the link
in word doc.s but nothing for Excel.

What I am after is a summary list of all the hyperlinks in a workboo
and which cell they're pointing at.

Also, what would be particularly handy would be to have the hyperlin
destination change when another row or column is inserted on th
destination worksheet. Rather than having to manually go through an
correct the links.

many thanks,
 
Top