I didn't realize from your posting that the data was in columns A to F
on sheet1. I though everything was in column A. Easy to fix.


+-------------------------------------------------------------------+
|Filename: Propagate-Routine.xlsm |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=405|
+-------------------------------------------------------------------+

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=164405

Microsoft Office Help