| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to compare two lists and identify cells with same numbers in | Excel Discussion (Misc queries) | |||
| Compare two worksheets and identify common entries | Excel Discussion (Misc queries) | |||
| HOW DO I COMPARE TWO SHEETS AND IDENTIFY WHICH CELLS DIFFER | Excel Discussion (Misc queries) | |||
| compare two spreadsheets and identify records that have any change | Excel Discussion (Misc queries) | |||
| How can I compare 2 sets of Social Security #'s and Identify dupes | Excel Discussion (Misc queries) | |||
Threaded Mode
