See Chip Pearson's page on unique and duplicates.
http://www.cpearson.com/excel/duplicat.htm

You should be able to cobble something together with this.

--
Regards,
Tom Ogilvy


"Martin French" wrote in message
om...
Hi
I have a database in Excel of existing customer account numbers. I
also have a list of new account numbers. I want to be able to check
the new list against the existing list and create two new list - one
list of new accounts already on the database, and another list of new
accounts not already on the database.
Does anybody know of a quick and simpe way of doing this in vba code?

Many thanks

Martin