I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the web.
I need to be able to know for each Person (First name +las tname) at a Branch, the differences in the Role and Date Appointed between the two Lists.
It is possible for a Branch that the Person is on one List but not on the other.
[Once the differences are identified the user will check what is the correct Information and make changes to the lists to get them to match]
I have tried using PQ Merge but couldn't get this to work.
Has anyone got any ideas
Thanks
Allister
I need to be able to know for each Person (First name +las tname) at a Branch, the differences in the Role and Date Appointed between the two Lists.
It is possible for a Branch that the Person is on one List but not on the other.
[Once the differences are identified the user will check what is the correct Information and make changes to the lists to get them to match]
I have tried using PQ Merge but couldn't get this to work.
Has anyone got any ideas
Thanks
Allister
Book2 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
4 | List 100 | List 200 | |||||||||||||
5 | Branch | Role | Appomited | First Name | Last Name | Branch | Job | First Name | Last Name | Appomited | |||||
6 | A | Worker | 1/03/2020 | Mickey | Mouse | A | Worker | Mickey | Mouse | 1/03/2020 | |||||
7 | B | Manager | 3/06/2019 | Donald | Duck | A | Manager | Goofy | Brown | 14/03/2018 | |||||
8 | A | Manager | 14/03/2018 | Goofy | Brown | A | Worker | Jasmin | Orange | 18/03/2012 | |||||
9 | A | Worker | 1/06/2007 | Jasmin | Orange | B | Worker | Harry | Hall | 1/04/2017 | |||||
10 | B | Worker | 30/08/2011 | Popey | Sailor | C | Manager | Jonny | Appleseed | 31/03/1945 | |||||
11 | B | Worker | 1/04/2017 | Harry | Hall | D | Worker | Sally | Trout | 30/12/2018 | |||||
12 | C | Manager | 31/03/1945 | Jonny | Appleseed | ||||||||||
13 | C | Worker | 11/11/2011 | Daffy | Tailor | ||||||||||
14 | |||||||||||||||
List 2 |