Automatic Dynamic Hyperlinks

[Everest3788]

I have a spreadsheet with multiple sheets of data upon which I am trying to automatically hyperlink identical cells in each sheet to one another as well as make the hyperlinks dynamic in nature so that if a cell is re-positioned within a sheet, the hyperlink will automatically update. I have found this code on the internet to create the dynamic hyperlink, however, with the amount of data I am generating, manually running this hyperlink has become time consuming and cumbersome. I had a friend who is experienced with Excel MACROS attempt to create an an automatic dynamic hyperlink code but after he had completed the worksheet, this code does not work the way I would like it to. What I would really like is to have someone explain to me how I can create the automatic dynamic hyperlink code so that I can know how the code works and trobleshoot it if theres ever a need. Please let me know if you can help, my brain has been exploding trying to figure this out.

Code for dynamic hyperlink:

Please Login or Register  to view this content.

This is the code my friend had generated in an attempt to make the automatic hyperlinks:

Please Login or Register  to view this content.

Any help is greatly appreciated, thanks so much

[FDibbins]

Hi, welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I will add them for you - this time )