| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
| copying cells from other worksheets | Excel Discussion (Misc queries) | |||
| Problems copying cells using offset and counta | Excel Discussion (Misc queries) | |||
| Automatic copying of data cells | Excel Discussion (Misc queries) | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Linear Mode
