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:
And the next column has the barcode part numbers scanned in
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:
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:
ActiveWorkbook.FollowHyperlink Address:= Range("C1"),
But it’s nowhere near right.
Can someone help please?