Forgot to ask...

Is there any unique fields (ie Personell number) because if there is, use
this as it is possible for 2 people to have the same name

Thanks,

Simon

smw226 wrote:
Hi GMK,

In theory it should work but, lets have another go....

Try doing a Vlookup between the 2 sheets and any N/A's will be new ones

or

Pop your data into access and run a query on it where tbl1.name<tbl2.name

Thanks,

Simon

I still get far too many records, most of which are not the ones I want to
retain.
[quoted text clipped - 13 lines]

Thanks.


--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1