copying a picture in a cell

[Soundman]

Hi all,

This seems like a simple problem, but here I am anyway. I have a series of simple pictures in a spreadsheet. Depending on what the user inputs into A1, I want A2 to show the corresponding picture. For example if the type "cat" in A1, the A2 would show a picture of a cat. The pictues are already in the spreadsheet, it's just a matter of finding a function that will copy the cell that it's in & paste it into A2. If I manually copy & paste the cell it works, but I'm looking for a formula that can do that.

I've also tried naming the picture & using an if function. IE: =if (A1="cat",cat,""). But what that did was paste the words "group312" in the cell instead of the picture.

I prefer to keep this away from turning into a VB project.

Can anyone help?

Thanks,
Bill

[Ken Johnson]

Soundman wrote:
> I prefer to keep this away from turning into a VB project.

Hi,
I'm pretty sure you're going to have to use VBA to do this.
It's not too difficult.
If you want to continue down that path let us know.

Ken Johnson

[Guytomlinson]

ok, saw your message and reply. How would you do it in vb? (ie. copy jpg pictures into CELLS of excel)

I have about 400 names (in an excel workbook) and pictures (in another folder) I want to create a new sheet with first few rows as extracts from worksheet then last bit a picture (into a large cell so that the size of the picture is always the same).

Yes I can do it as fill effects but that is not what I want...

Regards Guy