Miguelluis
New Member
- Joined
- Jan 29, 2013
- Messages
- 45
Hi, I need to maintain a list of clients for a specific purpose.
For this I receive a daily report with a list of clients that fit into this criteria and I need to identify when the daily report and the clients it contains changes. I need to identify when clients appear on the report as well when they disappear.
Let's say the daily report contains this data:
<tbody>
</tbody>
What I had in mind is having a front sheet called "Client Database" on a workbook called "Client List" , then when I copy the daily report into another sheet maybe called "Daily Report" into the same workbook the "Client Database" sheet would appear like shown below:
<tbody>
</tbody>
The No change is where the client ID is on the front sheet and on the daily report
The New is when the client ID is on the daily report but not on the "client database" sheet
The Deleted is when the client is on the "client database" but not on the daily report.
Is this possible? I've looked online but I can't find anything that fits this.
Any help will be amazing, thanks.
Miguel
For this I receive a daily report with a list of clients that fit into this criteria and I need to identify when the daily report and the clients it contains changes. I need to identify when clients appear on the report as well when they disappear.
Let's say the daily report contains this data:
| Client ID | Category | Registered Address |
| 123456 | Person | NG |
| 123457 | Person | PK |
| 123458 | Person | VE |
| 123459 | Person | TH |
| 123460 | Person | ZW |
| 123461 | Person | KE |
| 123462 | Person | MW |
| 123463 | Person | TH |
| 123464 | Person | UG |
| 123465 | Person | NG |
| 123466 | Person | NG |
| 123467 | Person | EC |
| 123468 | Person | PK |
| 123469 | Person | TH |
| 123470 | Person | EG |
| 123471 | Person | MM |
| 123472 | Person | JM |
| 123473 | Person | ZM |
| 123474 | Person | KE |
| 123456 | Person | NG |
| 123456 | Person | IR |
<tbody>
</tbody>
What I had in mind is having a front sheet called "Client Database" on a workbook called "Client List" , then when I copy the daily report into another sheet maybe called "Daily Report" into the same workbook the "Client Database" sheet would appear like shown below:
| Client ID | Category | Registered Address | Result |
| 123456 | Person | NG | New |
| 123457 | Person | PK | Deleted |
| 123458 | Person | VE | No Change |
| 123459 | Person | TH | No Change |
| 123460 | Person | ZW | No Change |
| 123461 | Person | KE | No Change |
| 123462 | Person | MW | No Change |
| 123463 | Person | TH | No Change |
| 123464 | Person | UG | No Change |
| 123465 | Person | NG | New |
| 123466 | Person | NG | No Change |
| 123467 | Person | EC | Deleted |
| 123468 | Person | PK | Deleted |
| 123469 | Person | TH | New |
| 123470 | Person | EG | No Change |
| 123471 | Person | MM | Deleted |
| 123472 | Person | JM | No Change |
| 123473 | Person | ZM | New |
| 123474 | Person | KE | No Change |
| 123456 | Person | NG | Deleted |
| 123456 | Person | IR | No Change |
<tbody>
</tbody>
The No change is where the client ID is on the front sheet and on the daily report
The New is when the client ID is on the daily report but not on the "client database" sheet
The Deleted is when the client is on the "client database" but not on the daily report.
Is this possible? I've looked online but I can't find anything that fits this.
Any help will be amazing, thanks.
Miguel
