Try this illustrative sample in my archives:
http://savefile.com/files/103141
Extracting an exclusion list.xls

Extract automatically in Z what's in Y which is not found in X (master list)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"Mossykel" wrote:
I have a master list of people and their ID number in worksheet 1. I'm
trying to find the missing individuals from what I have in worksheet 2 and
put them in a new worksheet 3. Please tell me the easiest way to do this...