I have a number of different regional account workbooks. In each, a
worksheet with company names, addresses, etc, and account numbers.Account
numbers are in column J.

I would like to access each company on the company server without creating
individual hyperlinks for each company. Anyway to create and copy a
hyperlink to refer to the account number in the J column cells. The
hyperlink is http://www.JJJ.com/KKK/LLL/acct.asp?id= (I've spoofed the
url) where the account number would be the number listed in cell and follow
the = sign.

Any easy way to do this?

Thanks for any advice.

Regards, Bob