Hi I was wondering if someone could help me.

I am creating a fairly simple excel data sheet to help out in work. I'll explain what I am trying to get it to do, then you might get the idea of where I am going wrong and hopefully point me in the right direction.

I deal will a lot of return parts from one manufacturer and at present we have to look up each part number of there on line site to see what it is.

So I have set up a spreadsheet with the first column containing the common search parameter replicated in each cell:

Example: http://h20141.www2.hp.com/hpparts/Se...earchCriteria=

And the next column has the barcode part numbers scanned in

Example: A9739-69008

In the following Colum I placed the formula =HYPERLINK(A1&""&B1) then copied and pasted in all the cells in the column.

The combined result gives me a hyperlink to that parts information:
http://h20141.www2.hp.com/hpparts/Se...ia=A9739-69008


Now although this works great as a hyperlink to each part description, it looks untidy.

What I want to do is create a button that can be pressed on each row than can do the same thing withoutlooking so untidy.

I tried to create a macro for a button on the first row with the following code:

Sub HP_link_2()
ActiveWorkbook.FollowHyperlink Address:= Range("C1"),
NewWindow:=True
End Sub

But it’s nowhere near right.

Can someone help please?