Hi John,

I know you posted in programming, but here is a formula solution I believe
will do what you want.

=IF(COUNTIF(Sheet1!$A$1:$A$6,Sheet2!A1)=0,Sheet2!A 1,"")

Where "Sheet1!$A$1:$A$6" is the old list (sheet1)
Where "Sheet2!A1" is the beginning of the new list (sheet2)

Pull formula down as far as the longest list goes. This should return
values from the new list that are NOT on the old list.

Copy and paste special values to a new column to get rid of formulas.
Select all in new column and sort to get rid of empty cells.

HTH
Regards,
Howard

"John" wrote in message
oups.com...
Can someone help me please? I have two sheets, one with last months
data and one with this months new data. I need to find a way to compare
the two and extract only the rows from the second sheet that do not
have a matching part number entry in the first sheet. Any help and
advice would be greatly appreciated.