Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
OzGhostRiding
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
OzGhostRiding
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
OzGhostRiding
 
Posts: n/a
Default

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   Report Post  
OzGhostRiding
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
text from one column into multiple columns Jeff Brown Excel Discussion (Misc queries) 6 December 22nd 04 11:07 PM
multiple text files URGENT tasha Excel Discussion (Misc queries) 1 December 19th 04 06:44 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 03:43 PM
Putting text in a column based on variable text from another colum Jacky D. Excel Discussion (Misc queries) 1 December 16th 04 07:09 PM
how do I easily convert a single column of text (multiple rows si. philmah Excel Discussion (Misc queries) 2 December 16th 04 01:24 AM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"