![]() |
Convert a picture to a cell address.
Have a file containing .tif images. The images have been bought into an excel
sheet and sized so as to be readable (40 H x 9 W). At the moment they are manually placed next to the data they represent. Ideally, I would like to use a function like VLOOKUP and retreive these pictures when the user enters a code they relate to . I'd like to retreive these pictures from ... a. the oiginal file were the images are kept... b. if not, then from a seperate workbook... c. if not, then from a seperate sheet in the same workbook... d. at worst, from the same sheet were tey are now. |
Convert a picture to a cell address.
Check out http://www.mcgimpsey.com/excel/lookuppics.html
Best o luck "Hector" wrote: Have a file containing .tif images. The images have been bought into an excel sheet and sized so as to be readable (40 H x 9 W). At the moment they are manually placed next to the data they represent. Ideally, I would like to use a function like VLOOKUP and retreive these pictures when the user enters a code they relate to . I'd like to retreive these pictures from ... a. the oiginal file were the images are kept... b. if not, then from a seperate workbook... c. if not, then from a seperate sheet in the same workbook... d. at worst, from the same sheet were tey are now. |
All times are GMT +1. The time now is 05:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com