zamzam
06-26-2010, 02:26 PM
Hi all,
I have a list of 2500 items where some of them are similar (not more than 2 in each similarity group) and I would like to "conect" them with a hyperlink. It means that when i click on the link, it jumps to the hyperlinked cell. The list is often being sorted and regular hyperlink does not survive that. I found a very close sulotion here on the website but I cannot add the link because I am new here. It is called "Dynamic hyperlink formula (http://www.vbaexpress.com/kb/getarticle.php?kb_id=237)" by byundt but it also does not survive the sorting process.
Can any one please help?
I have a list of 2500 items where some of them are similar (not more than 2 in each similarity group) and I would like to "conect" them with a hyperlink. It means that when i click on the link, it jumps to the hyperlinked cell. The list is often being sorted and regular hyperlink does not survive that. I found a very close sulotion here on the website but I cannot add the link because I am new here. It is called "Dynamic hyperlink formula (http://www.vbaexpress.com/kb/getarticle.php?kb_id=237)" by byundt but it also does not survive the sorting process.
Can any one please help?