I have created a personal list of contacts with two sheets: "sheet 1"with
private contacts and "sheet 2" with buissness contacts. Certain people in
"sheet 1" are hyperlinked to certain bussiness in "sheet 2" and viceversa but
as I update my contacts and keep them alphabetically I have to insert rows
and that changes the name of the cells. For example if cell A2 in "sheet 1"is
hyperlinked to cell E2 in "sheet 2" and I insert a row in "sheet 2" then cell
E2 in "sheet 2" becomes cell F2. However cell A2 in "sheet 1" remaines linked
to cell E2 in "sheet 2" which is noot the right link anymore. How can I get
arround this?
--
Gabi