Hi, there's gotta be a simple solution but I don't know what it is. I don't know OLE or VB or whatever programming that might make this happen.
Let's say A1 is text that says "Office Policies" and is hyperlinked to go to A60 where it also says "Office Policies." <----that part's easy.
But how can I configure the hyperlink so that if somebody inserts 3 rows between rows 1 and 60, and the text that says "Office Policies" is now in cell A63, that the hyperlink WILL GO TO A63 and automatically adjust for inserted (or deleted) rows?
If I could hyperlink to a thumbnail picture on the worksheet that says "Office Policies," that would be easy but I don't know how or if I can.
Excel 2007 and also 2003
Thanks for your help!
Jcj
Bookmarks