I have two similarly formatted lists on different worksheets in the same workbook.
List A is my master list. List B, which changes weekly, has some values that exist on List A along with completely new values.
Each list has about 2,300 rows. I must compare these two lists and find the new values on List B. Ordinarily, I could find the changes if the data on every row had a value across multiple columns. But these lists are like the example below:
List A
<tbody>
</tbody>
List B
<tbody>
</tbody>
The names in red are the new values that I need to identify, but also need to know the relationship they have with Region 1 and the three Departments. So if I find that "roger" has been added, I must also know that he's under Department 2, which is under Region 1.
I welcome any input to help me figure this puzzle out. Thanks.
List A is my master list. List B, which changes weekly, has some values that exist on List A along with completely new values.
Each list has about 2,300 rows. I must compare these two lists and find the new values on List B. Ordinarily, I could find the changes if the data on every row had a value across multiple columns. But these lists are like the example below:
List A
Grandparent | Parent | Child |
Region 1 | Department 1 | apple |
orange | ||
mickey | ||
Minnie | ||
Department 2 | clark | |
bruce | ||
mary | ||
louise | ||
Department 3 | george | |
rick | ||
sally | ||
Region 2 | Department 4 | jojo |
bob | ||
Robert |
<tbody>
</tbody>
List B
Grandparent | Parent | Child |
Region 1 | Department 1 | apple |
orange | ||
mickey | ||
Minnie | ||
cisco | ||
david | ||
Department 2 | clark | |
bruce | ||
mary | ||
louise | ||
roger | ||
stephen | ||
Department 3 | jojo | |
bob | ||
Robert | ||
marcus |
<tbody>
</tbody>
The names in red are the new values that I need to identify, but also need to know the relationship they have with Region 1 and the three Departments. So if I find that "roger" has been added, I must also know that he's under Department 2, which is under Region 1.
I welcome any input to help me figure this puzzle out. Thanks.