You should get some ideas he

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"MESTRELLA29" wrote in message
...
I have two list (on in Sheet1, another in sheet2), sheet1 gets updated
from
downloads & sheet2 updates with SUMPRODUCT by Prodcut No.
how do I go about in finding any new part no. in sheet1 that are not in
sheet2