LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default import shape from other sheet based on destination sheet data


Here's the workbook. The idea is to cycle through the red tabbed sheets,
and if the value of any of the blue-tabbed sheets' name is found in
column AH, copy the shape called "linedrawing" from the corresponding
blue-tabbed sheet into the red-tabbed sheet.
Except it doesn't work.....


+-------------------------------------------------------------------+
|Filename: TestImportShapes.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=124|
+-------------------------------------------------------------------+

--
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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy rows from one Data sheet to another sheet based on cell conte John McKeon Excel Discussion (Misc queries) 2 May 15th 10 06:49 AM
copied formulas refer to destination sheet not source sheet Dantron Excel Worksheet Functions 2 October 21st 09 09:51 PM
sort source data sheet while destination shows same data Inobugs Excel Worksheet Functions 1 April 18th 09 09:36 PM
Move data to new sheet - rename sheet based on criteria ? [email protected] Excel Discussion (Misc queries) 7 May 16th 07 10:22 PM
Create new sheets based off Data sheet, and template sheet Midget Excel Programming 2 May 1st 07 09:55 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"