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 |
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 |