Extracting data from one sheet unless it is also on a second works

[Victoria]

hi

Sheet1 of my workbook has data under columns EmpID, LastName, FirstName, dob.

Sheet2 has the same structure, but with different data. But, there is
overlap - some of the data is found in both sheets.

Here is my problem: I want data on Sheet3 (also with the same structure) to
show ALL data rows from Sheet1 EXCEPT those found on Sheet2. I'm quite new
to Excel programming, so I'd really appreciate any clues as to how to do
this. There are enough data rows that I don't want to always have to do this
'by hand'.

much thanks
Victoria

 

[Victoria]

Joel - thanks very much. Works like a charm!
Victoria