Excel: Use pic location string to call up picuture in cell?
 

In excel, I want to show a small picture of the inventory listed. I have all
my inventory pictures saved in a folder on my desktop...Other than the
obvious of going to Insert Picture From file menu...is there a way that I
can fill in a directory location in the cell to bring up a picture for each
inventory item? For example: In they Inventory 1 row I would like to insert
something like... c:/desktop...../inventory1.jpg and it will link to the
desktop folder where i have previously saved inventory1.jpg and bring up the
picture inventory1.jpg in that cell.

Excel: Use pic location string to call up picuture in cell?
 

Hi

With a list of your items in column A, enter this formula in B1 and copy
down

=HYPERLINK("C:\Documents and Settings\Roger\My Documents\My Pictures\"
&"Phoebe "&TEXT(ROW(),"000")&".jpg",A1)

Phoebe is the name of our Labrador, and this brings up each of the pictures
Phoebe 001.jpg, Phoebe 002.jpg etc.
Adjust to suit your file locations and naming conventions.

--
Regards
Roger Govier



"vloh28" wrote in message
...
In excel, I want to show a small picture of the inventory listed. I have
all
my inventory pictures saved in a folder on my desktop...Other than the
obvious of going to Insert Picture From file menu...is there a way
that I
can fill in a directory location in the cell to bring up a picture for
each
inventory item? For example: In they Inventory 1 row I would like to
insert
something like... c:/desktop...../inventory1.jpg and it will link to the
desktop folder where i have previously saved inventory1.jpg and bring up
the
picture inventory1.jpg in that cell.