Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating multiple hyperlinks from a column where the text in the .
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. |
#2
|
|||
|
|||
Hi
in B3 enter: =HYPERLINK("www.website.com/generic/" & A3 & "/" & A3 & ".html",A3) -- Regards Frank Kabel Frankfurt, Germany "OzGhostRiding" schrieb im Newsbeitrag ... 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. |
#3
|
|||
|
|||
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? "Frank Kabel" wrote: Hi in B3 enter: =HYPERLINK("www.website.com/generic/" & A3 & "/" & A3 & ".html",A3) -- Regards Frank Kabel Frankfurt, Germany "OzGhostRiding" schrieb im Newsbeitrag ... 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. |
#4
|
|||
|
|||
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 ToolsOptionsEdit and check "allow cell drag and drop" Gord Dibben Excel MVP On Sun, 12 Dec 2004 14:37:12 -0800, "OzGhostRiding" wrote: 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? "Frank Kabel" wrote: Hi in B3 enter: =HYPERLINK("www.website.com/generic/" & A3 & "/" & A3 & ".html",A3) -- Regards Frank Kabel Frankfurt, Germany "OzGhostRiding" schrieb im Newsbeitrag ... 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. |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Thanks to Both of you!
PEBKAC! I forgot to add the http:// to the front of the links! D'UH! Cheers Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text from one column into multiple columns | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) |