you could take a copy of sheet1 and delete any duplicates.

to copy
right click onto the sheet tab
select move or copy
tick the square to take a copy


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=477194