I hope that the attached solves the first of the problems - you can see
the code by hitting ALT F11 and going to the sheet1 tab.
I don't fully understand the sheet 3 format, what happens if the data
is in something other than the first column.
+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4753 |
+-------------------------------------------------------------------+
--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=535260