Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a picture based on Excel Value
Hi!
Running Excel 2003. I'm creating a workbook with all of my employee's information in it. I've created a master sheet where the user types in a employee's name and then it references to all the information that I have on the employee across each worksheet. Most of it just uses simple VLOOKUP to reference and return the wanted information. Based on the name typed in I would like to be able to bring up a picture of the employee too and show it in a designated cluster of cells. I have pics of each employee in a separate folder on my computer. Any help would be much appreciated and as many details as possible would be great! Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a picture based on Excel Value
Hi tdawg79
See http://www.mcgimpsey.com/excel/lookuppics.html -- Regards Ron de Bruin http://www.rondebruin.nl "tdawg79" wrote in message ups.com... Hi! Running Excel 2003. I'm creating a workbook with all of my employee's information in it. I've created a master sheet where the user types in a employee's name and then it references to all the information that I have on the employee across each worksheet. Most of it just uses simple VLOOKUP to reference and return the wanted information. Based on the name typed in I would like to be able to bring up a picture of the employee too and show it in a designated cluster of cells. I have pics of each employee in a separate folder on my computer. Any help would be much appreciated and as many details as possible would be great! Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a picture based on Excel Value
Hi T,
See J.E. McGimpsey's Picture Lookup page at: http://www.mcgimpsey.com/excel/lookuppics.html --- Regards, Norman "tdawg79" wrote in message ups.com... Hi! Running Excel 2003. I'm creating a workbook with all of my employee's information in it. I've created a master sheet where the user types in a employee's name and then it references to all the information that I have on the employee across each worksheet. Most of it just uses simple VLOOKUP to reference and return the wanted information. Based on the name typed in I would like to be able to bring up a picture of the employee too and show it in a designated cluster of cells. I have pics of each employee in a separate folder on my computer. Any help would be much appreciated and as many details as possible would be great! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
all my shortcuts to excel files open up as a picture | Excel Discussion (Misc queries) | |||
Can't open picture file link in Excel, Error no program registere. | Excel Discussion (Misc queries) | |||
Inserting picture into excel based on # in the another cell | Excel Worksheet Functions | |||
open gif with picture and fax viewer from Excel | Excel Discussion (Misc queries) | |||
how do I show a picture in excel based on cell data | Excel Discussion (Misc queries) |