| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare and identify new data
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 "Dave Baffled" wrote in message ... 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 ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare and identify new data
OK, lets delete everything that matches, leaving only the
new data. -----Original Message----- 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 "Dave Baffled" wrote in message ... 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 ----== Posted via Newsfeed.Com - Unlimited-Uncensored- Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- . |
| Reply |
| 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) | |||
Linear Mode
