software

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?

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: www.msn.com/
B1: MSN
C1: =HYPERLINK(A1,B1)

Does that help?

***********
Regards,
Ronquot;basuquot; wrote:

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

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.

quot;Ron Coderrequot; wrote:

gt; You might be able to use Excel's HYPERLINK function:
gt;
gt; =HYPERLINK(link_location, friendly_name)
gt;
gt; Perhaps you could list the URL in Col_A, the display name in Col_B, and
gt; refer to those columns in the formula:
gt;
gt; Example:
gt; A1: www.msn.com/
gt; B1: MSN
gt; C1: =HYPERLINK(A1,B1)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;basuquot; wrote:
gt;
gt; gt; I have a large excel file and want all product codes to link directly to
gt; gt; images. There are about 3000 of them and doing it manually will take
gt; gt; forever. Is there an easier way?

Not sure exactly how this would help, but... can you do a quot;Dir /b gt;
filename.extquot; 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?quot;holmeshousequot; gt; wrote in message
...
gt; Thanks but the images that I want to link to the cells are in a different
gt; file. I am not sure how this would work. I can hyperlink them one by
one,
gt; but this would take so long. Appreciate your input, though.
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; You might be able to use Excel's HYPERLINK function:
gt; gt;
gt; gt; =HYPERLINK(link_location, friendly_name)
gt; gt;
gt; gt; Perhaps you could list the URL in Col_A, the display name in Col_B, and
gt; gt; refer to those columns in the formula:
gt; gt;
gt; gt; Example:
gt; gt; A1: www.msn.com/
gt; gt; B1: MSN
gt; gt; C1: =HYPERLINK(A1,B1)
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt;
gt; gt; quot;basuquot; wrote:
gt; gt;
gt; gt; gt; I have a large excel file and want all product codes to link directly
to
gt; gt; gt; images. There are about 3000 of them and doing it manually will take
gt; gt; gt; forever. Is there an easier way?