Move drawing to cells

[Sandra]

1. I have 3 sheets.
2. On Sheet1 the user enters "1", "2", "3", or nothing in
each cell of rows 5 through whatever, beginning in colum
B.
3. On Sheet2 I have 3 drawings - 1 in A1, another in A2,
another in A3.
4. On Sheet3 I want the drawing in A1 to appear in cells
that correspond to Sheet1, if the user enters "1" in
Sheet1. If he enters "2", I want the drawing from cell A2
to appear. If he enters "3", I want the drawing from cell
A3 to appear.
For example, if he enters "1" in cell c6 of Sheet 1, I
want the drawing from A1 to appear in c6 of Sheet 3.

Can one of you experts out there tell me how?

 

[JE McGimpsey]

I'm not sure what you mean by drawings "in" cells - are these pictures
pasted into the worksheet's drawing layer (which is actually above the
cell layer), and positioned over cells A1:A3?

You may be able to adapt this:

http://www.mcgimpsey.com/excel/lookuppics.html