Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2000 - How to find cell location of a link to another file? | Excel Discussion (Misc queries) | |||
find a character location in a string starting from the right | Excel Worksheet Functions | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Location of the last "s" in a text string | Excel Worksheet Functions | |||
hyperlink an excel cell to a specific location wthin application f | Excel Discussion (Misc queries) |