Using the contents of a cell to hyperlink another

[scatlett]

I have a large index of parts. In column A I have the Part Name, and in Column H I have a location where its information can be found. I would like to write a macro that would copy the contents in Column H as the hyperlink address for Column A for the entire file.

I have been reading and trying and tutorialing but just can't get it. Searches have also come up just a bit shy of useful information.

Thanks for any suggestions!

Steven