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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top