if you are familiar with VBA, then you could use some sample exce
sheets from debra's website www.contextures.com to hit the groun
running.

go over to the Files link, and download two sample files CopyToWkbk.xl
and ExtractUnique.xls. you could tweak and combine the two to get a cod
which fits your requirement

--
icestationzbr
-----------------------------------------------------------------------
icestationzbra's Profile: http://www.excelforum.com/member.php...nfo&userid=458
View this thread: http://www.excelforum.com/showthread.php?threadid=26354