Creating multiple hyperlinks from a column where the text in the .

[Guest]

I wish to link an excel pricelist to a company website with the product
descriptions using the product codes listed in column A. There are
approximately 1500 product codes.
example:
Cell a3 has the value 12345
hyperlink is www.website.com/generic/12345/12345.html
and so on down the column.

 

[Frank Kabel]

Hi
in B3 enter:
=HYPERLINK("www.website.com/generic/" & A3 & "/" & A3 & ".html",A3)

 

[Guest]

Thanks Frank. Now apart from manually entering each hyperlink, a tedious job
for 1500 links is there a way I can apply that hyperlink to an entire column
so each code links to it's corresponding page?

 

[Gord Dibben]

Have you tried drag/copy down?

A3 will increment as you drag.

Click and hold on the cell then grab fill handle at lower right corner of cell
and drag down the column.

If you don't see a fill handle(black lump and cross) go to Tools>Options>Edit
and check "allow cell drag and drop"

Gord Dibben Excel MVP

 

[Guest]

I've done the dragdown and when I hover my mouse over the hyperlinks the
correct hyperlink is shown but they refuse to work when I click on them.
I know the pages exist, yet excel gives me a "cannot open the specified
file" error message on every link.
If I enter the link manually it works, but those auto ones don't.
Thanks!
Phil

 

[Guest]

Thanks to Both of you!
PEBKAC!
I forgot to add the http:// to the front of the links! D'UH!

Cheers
Phil