I'd just use another column of cells and the =hyperlink() worksheet function:

=hyperlink("http://www.whatever.com/" & a2,"Click me")

or something like this.

wrote:

Hi,

I am terribly bad with loops and was hoping someone could help me with
some code.

I have column A, called Item. It has numbers in it.

ex:
Item
123
124
234
223

I need to loop through all the non blank cells in the column and add a
hyperlink to each item number. They hyperlink would be something like
http:....123. The ticket number would be at the end. The main part of
the hyperlink excluding the ticket number is always the same.

Thanks for anyone who can assist.

--

Dave Peterson