how do I set up multiple (3,000) hyperlinks in excel quickly?

B

basu

I have a large excel file and want all product codes to link directly to
images. There are about 3000 of them and doing it manually will take
forever. Is there an easier way?
 
R

Ron Coderre

You might be able to use Excel's HYPERLINK function:

=HYPERLINK(link_location, friendly_name)

Perhaps you could list the URL in Col_A, the display name in Col_B, and
refer to those columns in the formula:

Example:
A1: http://www.msn.com/
B1: MSN
C1: =HYPERLINK(A1,B1)

Does that help?

***********
Regards,
Ron
 
H

holmeshouse

Thanks but the images that I want to link to the cells are in a different
file. I am not sure how this would work. I can hyperlink them one by one,
but this would take so long. Appreciate your input, though.
 
4

43fan

Not sure exactly how this would help, but... can you do a "Dir /b >
filename.ext" to get a list of all the files into a text file, then import,
or copy and paste the list of names into an Excel sheet, and then using
copy/paste, set up the hyperlinks that way? Possibly using the other
poster's suggestion as well?
 
Top