Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting picture into excel based on # in the another cell
Hello all,
I am trying to figure out how I can insert a picture (jpg) based on a number in another box. I have a database of over 16,000 pictures of items that are placed into surgical kits sent to hospitals around the world for surgery the next day from our distribution center. We are taking a picture of every item in our inventory. Ex. titanium screws for spinal surgery. Once the pictures are taken we rename the file to the reflect the part # of the item in the picture. Thus, the file name will be unique to that part # (i.e.unv1001.jpg). So if I enter the part # unv1001 in box A1 - it will look for that string (unv1001) in c:\pics\ and insert that jpg (unv1001.jpg) into B2. The point of doing this is that we will place this photo with the Part # and location next to each location where the item is stored. This will dractically reduce the # of items picked wrong in the facility. When we type in all the part # into column 'A' then the picture of that item will be displayed in column 'B'. This will prevent surical kits from having the wrong items picked. Any help is most appreciated as always, Thank you Bo Staggs |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting picture into excel based on # in the another cell
Programmatically............see JE McGimpsey's site for a method of showing
hidden pictures based upon a value in a cell. http://www.mcgimpsey.com/excel/lookuppics.html BTW........a picure cannot be "inserted" into a cell, just on top of that cell. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 17:45:14 GMT, "jstaggs" <u30225@uwe wrote: Hello all, I am trying to figure out how I can insert a picture (jpg) based on a number in another box. I have a database of over 16,000 pictures of items that are placed into surgical kits sent to hospitals around the world for surgery the next day from our distribution center. We are taking a picture of every item in our inventory. Ex. titanium screws for spinal surgery. Once the pictures are taken we rename the file to the reflect the part # of the item in the picture. Thus, the file name will be unique to that part # (i.e.unv1001.jpg). So if I enter the part # unv1001 in box A1 - it will look for that string (unv1001) in c:\pics\ and insert that jpg (unv1001.jpg) into B2. The point of doing this is that we will place this photo with the Part # and location next to each location where the item is stored. This will dractically reduce the # of items picked wrong in the facility. When we type in all the part # into column 'A' then the picture of that item will be displayed in column 'B'. This will prevent surical kits from having the wrong items picked. Any help is most appreciated as always, Thank you Bo Staggs Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel insert rown based on variable data in a cell? | Excel Worksheet Functions | |||
MS Excel 2003 - inserting an editors name into a cell | Excel Discussion (Misc queries) | |||
Can an Excel formula be created to paste a picture in a cell? | Excel Worksheet Functions | |||
EXCEL : Replace a value in a cell by a picture | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |