| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import shape from other sheet based on destination sheet data
I need to import a shape from a sheet in my current workbook based on the value of a non-empty cell in column B. I have several sheets in which I need to import shapes in Column A (the shapes all have the same name). These shapes are in other sheets named after the value in column B. I need to search column B of the destination sheet for a shape name (ex: SH01), and then search the workbook for a sheet named "SH01", copy the shape in A1 fro "SH01" into the destination sheet. -- thole ------------------------------------------------------------------------ thole's Profile: http://www.thecodecage.com/forumz/member.php?userid=271 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91727 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
import shape from other sheet based on destination sheet data
thole;328278 Wrote: I need to import a shape from a sheet in my current workbook based on the value of a non-empty cell in column B. I have several sheets in which I need to import shapes in Column A (the shapes all have the same name). These shapes are in other sheets named after the value in column B. I need to search column B of the destination sheet for a shape name (ex: SH01), and then search the workbook for a sheet named "SH01", copy the shape in A1 fro "SH01" into the destination sheet.Why do you need to import the shape rather than create a similar one depending on the data? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91727 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
import shape from other sheet based on destination sheet data
Simon Lloyd;334266 Wrote: Why do you need to import the shape rather than create a similar one depending on the data? Can you attach your workbook so we can help you directly with that? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91727 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
import shape from other sheet based on destination sheet data
The shape is a picture -- thole ------------------------------------------------------------------------ thole's Profile: http://www.thecodecage.com/forumz/member.php?userid=271 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91727 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
| sort source data sheet while destination shows same data | Excel Worksheet Functions | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| Create new sheets based off Data sheet, and template sheet | Excel Programming | |||
Hybrid Mode
