I have a single workbook, one sheet has graphics which have Hyperlinks to cells in other sheets.
My problem is the data in the other sheets may increase or decrease and hence the cell reference for the Hyperlink would have changed so the Hyperlink then links to the wrong place.
I am sure there must be an easy way to maintain that relationship ?
