Automated Image Replacement Suggestion

[Pc1x1]

Good Evening everyone,

I am currently looking to figure out the best way to do some image replacements in Excel.

Basically the pictures may change every so often, and we have a root folder where all the pictures are stored.

I would like Excel to Index and Match the pictures based on the item number that we assigned each picture. Is this possible with conditional formatting or do I have to make a macro?

Example:
Picture placeholder that is 300x300 is in the excel file.
Picture Folder that has 300x300 pictures is in the same directory.
Some pictures are updated and I move them to the Picture Folder.
I now F9 or open excel, all the pictures are loaded from that folder, and are in the same position as the previous placeholder.

Is this possible, and what about be your suggestions on going about this. I am thinking something like INDEX and MATCH, but how can it match the picture. I am thinking naming all the pictures the same code, as the code on the spreadsheet. And from that, it replaces the picture.

Thanks!

 

[Derek Brown]

Have a look at the following - it actually describes how to link and display pictures as comments but may give you an idea of how to solve your problem:
http://www.youtube.com/watch?v=MzF_5DXhqbs

 

[Pc1x1]

Have a look at the following - it actually describes how to link and display pictures as comments but may give you an idea of how to solve your problem:
http://www.youtube.com/watch?v=MzF_5DXhqbs

Thanks.
It's a start, but I need to not be a comment, because it needs to be in a specific place, aka a Cell.

To simplify:

I have the pictures already in a cell, and used placeholders, I need something that will replace those pictures, automatically by looking up the product number (typed into my sheet already), and then looking at a folder in my HDD, that has the samenumber.jpg, and replacing the placeholder with it, its location etc has to be preserved.

Hopefully this makes more sense. Thanks.

 

[Pc1x1]

I am still looking at options, but it seems that the comments thus far seems to be the only viable. I hope theres more options .

 

[Pc1x1]

Still haven't found the best solution yet, wonder if theres any options with Macros?