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


--
Soundman
------------------------------------------------------------------------
Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=556778

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

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


--
Guytomlinson
------------------------------------------------------------------------
Guytomlinson's Profile: http://www.excelforum.com/member.php...o&userid=22201
View this thread: http://www.excelforum.com/showthread...hreadid=556778