Maybe
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"mrdata" wrote in message
...

If I have a worksheet that contains this:

Apples
Oranges
Pears

And I have another worksheet that contains:

Apples
Oranges
Pears
Tangerines

How do I scan the worksheet and find Tangerine isn't on the first
worksheet
and have it copy to the first worksheet without recopying Apples
Oranges Pears

I don't even know where to start this is a simple example of a more
complex worksheet.

Thanks
Charles


--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899
View this thread: http://www.excelforum.com/showthread...hreadid=528779