Create hyperlinks automatically from list of values

Hello

I have a list (constantly being added to) of Account Numbers such as the folowing

218397
2938232
239823
2343434

I would like a button at the top of my worksheet that I can press periodically to convert every cell into a Hyperlink with the following structure:

websiteurl/ACCOUNT NUMBER/view

Everything about the link will always be the same except for the account number.

It's important that the cell still shows the account number and not the link address.

Is this easy to do?

Note that sometimes I might change an account number in the middle of the list, so the Macro would need to look for any accounts where either the hyperlink is wrong or missing entirely.

Would really appreciate any help that can be provided!

This looks at the cells in the named range "mylist" and updates the hyperlinks if the cells contain text or deletes the link if it's empty.
[AccountNumber] is a placeholder that gets replace by the account number in the cell.

Please Login or Register  to view this content.

Originally Posted by ByteMarks

This looks at the cells in the named range "mylist" and updates the hyperlinks if the cells contain text or deletes the link if it's empty.
[AccountNumber] is a placeholder that gets replace by the account number in the cell.

Please Login or Register  to view this content.

Thanks! I've just seen this. I will try and report back