Compare and identify new data

  • Thread starter Thread starter Dave Baffled
  • Start date Start date
D

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
 
First define what you want to do!

You have specfiied three alternatives, presumably one of these is the
preferred option?

My suggestion is do not start coding until you have figured out the process.

Cheers
N
 
Back
Top