Connect a number to a picture bank and import that picture to exce
in [General]
|
Prev: Syntax for stopping a Do Loop?
Next: How to prevent Cut&Paste to change style and data validation on protected sheet
From: Dennis Hedo Dennis on 22 Mar 2010 09:51 I have a colum with numbers for specific products (example 111,123456) and I want a picture in the colum to the right of it that matches the number. On the computer I have a folder with pictures named with the product numbers. So my question is: Is there a function to link the the number in for example cell A1 with the picture that has the same name as the value in A1 and put that picture in cell B1. Thanks to whom ever have an answer, it would help my life. Best Regards Dennis
From: John on 22 Mar 2010 10:17
Hi Dennis Have a look at this site : http://www.mcgimpsey.com/excel/lookuppics.html HTH John "Dennis Hedo" <Dennis Hedo(a)discussions.microsoft.com> wrote in message news:14B5F8D4-A513-437A-A5AE-22B78D19F973(a)microsoft.com... >I have a colum with numbers for specific products (example 111,123456) and I > want a picture in the colum to the right of it that matches the number. On > the computer I have a folder with pictures named with the product numbers. > > So my question is: Is there a function to link the the number in for example > cell A1 with the picture that has the same name as the value in A1 and put > that picture in cell B1. > > Thanks to whom ever have an answer, it would help my life. > > Best Regards > Dennis |