copying cells

In cell A1 sheet1 I have a number which lets say represents a code for a
specific shape that i have allready drawn in cell B1 in sheet2.Can you please
tell me what kind of instruction i can give to cell B1,sheet1,so that i can
get that shape from cell B1 sheet2 into B1 sheet1?

How about putting those shapes on Sheet1 and hide them. Then you could have a
macro unhide the one you want.

J.E. McGimpsey shares this in a macro at his site:
http://www.mcgimpsey.com/excel/lookuppics.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

You could also have a macro that copies and pastes, but hiding/unhiding seems
easier (to me).

Christos P wrote:
>
> In cell A1 sheet1 I have a number which lets say represents a code for a
> specific shape that i have allready drawn in cell B1 in sheet2.Can you please
> tell me what kind of instruction i can give to cell B1,sheet1,so that i can
> get that shape from cell B1 sheet2 into B1 sheet1?

--

Dave Peterson

I really thank you for your help!!!!

"Dave Peterson" wrote:

> How about putting those shapes on Sheet1 and hide them. Then you could have a
> macro unhide the one you want.
>
> J.E. McGimpsey shares this in a macro at his site:
> http://www.mcgimpsey.com/excel/lookuppics.html
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> You could also have a macro that copies and pastes, but hiding/unhiding seems
> easier (to me).
>
> Christos P wrote:
> >
> > In cell A1 sheet1 I have a number which lets say represents a code for a
> > specific shape that i have allready drawn in cell B1 in sheet2.Can you please
> > tell me what kind of instruction i can give to cell B1,sheet1,so that i can
> > get that shape from cell B1 sheet2 into B1 sheet1?
>
> --
>
> Dave Peterson
>

Dear Dave can you please assist me with YOUR suggestion(hiding/unhiding) with
a macro?

"Dave Peterson" wrote:

> How about putting those shapes on Sheet1 and hide them. Then you could have a
> macro unhide the one you want.
>
> J.E. McGimpsey shares this in a macro at his site:
> http://www.mcgimpsey.com/excel/lookuppics.html
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> You could also have a macro that copies and pastes, but hiding/unhiding seems
> easier (to me).
>
> Christos P wrote:
> >
> > In cell A1 sheet1 I have a number which lets say represents a code for a
> > specific shape that i have allready drawn in cell B1 in sheet2.Can you please
> > tell me what kind of instruction i can give to cell B1,sheet1,so that i can
> > get that shape from cell B1 sheet2 into B1 sheet1?
>
> --
>
> Dave Peterson
>

J.E. McGimpsey's macro at that first link is a version that will hide/unhide
pictures.

If you had trouble with that, post back.

Christos P wrote:
>
> Dear Dave can you please assist me with YOUR suggestion(hiding/unhiding) with
> a macro?
>
> "Dave Peterson" wrote:
>
> > How about putting those shapes on Sheet1 and hide them. Then you could have a
> > macro unhide the one you want.
> >
> > J.E. McGimpsey shares this in a macro at his site:
> > http://www.mcgimpsey.com/excel/lookuppics.html
> >
> > If you're new to macros, you may want to read David McRitchie's intro at:
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> >
> > You could also have a macro that copies and pastes, but hiding/unhiding seems
> > easier (to me).
> >
> > Christos P wrote:
> > >
> > > In cell A1 sheet1 I have a number which lets say represents a code for a
> > > specific shape that i have allready drawn in cell B1 in sheet2.Can you please
> > > tell me what kind of instruction i can give to cell B1,sheet1,so that i can
> > > get that shape from cell B1 sheet2 into B1 sheet1?
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson