View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Baffled Dave Baffled is offline
external usenet poster
 
Posts: 1
Default Compare and identify new data

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