Macro to Insert Picture depending on cell detail

Hi,

I'm not sure if what I'm trying to do is possible so I'm hoping someone can at least answer that.

I have a spreadsheet with a list of Brands in column A and each brand has a logo. The logo needs to go in column B depending on which Brand is in column A. So far, this is being done by copying and pasting the image for each brand but this is proving quite time consuming!

Is there any way of creating a macro/ process to do this?

If anyone can advise, that would be a great help!

Thanks,
Lewis

http://excel.tips.net/T003128_Displa..._a_Result.html

This explains it quite well. I guess it probably depends on what foremat you have the logo's in but it looks fairly simple.

Hi Brendan,

Good effort! Unfortunately this method will only change the picture on 1 row. So for example, if cell A1 says Apple, it'll be a picture of an apple; or if it say Orange, it's a picture of an Orange - it can't be transferred onto other rows (well it can but it would be as easy to copy and paste the image you want, which is what I'm currently doing).

Adopting the idea of fruits above, my spreadsheet has Orange in A1, Apple in A2, Pear in A3, Pear in A4, Apple in A5 (and so on) and I need to put the corresponding picture into B1, B2, B3 etc.

Thanks for your idea though, a definte good suggestion!
Lewis

I think you are going to have to go the UDF route. Name the logo's as what is in the column being looked up, amend the directory and file extension accordingly and add =showpic(lookup_value). Width and height currently set to 200. Assuming the lookupvalue is the same as the filename it will return the picture.

You can copy the =showpic(lookup_value) down the sheet.

Please Login or Register  to view this content.