hyperlink w/in excel loses reference
this is the situation
person cell id hyperlink
Adams b20 b20
Jones b50 b50
Zilch b99 b99
If I create a hyperlink at Zilch to Jones the hyperlink = b50
then if I add a person above Jones (b50), the Jones info moves down and...