Compare and identify new data

[Dave Baffled]

I have a sheet called MasterData with Cust name - Cust # -
Job # and other stuff.

I will also have a sheet NewData that will be populated
with new data daily. The majority of the new data is
identical to the MasterData sheet. I need to identify
what is in the NewData that is not in MasterData.

Identification could be by any of the following methods:
Deleting all rows that DO match MasterData in NewData or
Highlighting all rows in NewData that DO NOT match.
Copy new rows from NewData into MasterData


Job # field will be the unique identifier.

How do I start this?

Dave

 

[Dave]

OK, lets delete everything that matches, leaving only the
new data.