I have the following problem that I need to solve with VBA:
I have two lists in the same sheet with 3 columns each with multiple rows (about 100). I would like to compare both lists and return the mismatches in another range in the same sheet.
The second list is the master list and the Shorter List is a subset of the Master List.
BEFORE
Shorter List: Master List:
<tbody>
</tbody>
AFTER
<tbody>
</tbody>
Thanks for your help!
I have two lists in the same sheet with 3 columns each with multiple rows (about 100). I would like to compare both lists and return the mismatches in another range in the same sheet.
The second list is the master list and the Shorter List is a subset of the Master List.
BEFORE
Shorter List: Master List:
Industry | Sub-Industry | Sub-Sub-Industry | Industry | Sub-Industry | Sub-Sub-Industry | |
AAA | BBB | CCC | DDD | BBB | FFF | |
AAA | BBB | PPP | AAA | BBB | CCC | |
DDD | BBB | EEE | AAA | BBB | PPP | |
XXX | YYY | UUU | DDD | BBB | EEE | |
OOO | RRR | TTT | XXX | YYY | ZZZ | |
XXX | YYY | UUU | ||||
OOO | PPP | QQQ |
<tbody>
</tbody>
AFTER
- this has to be written next to the Master List on the same sheet
- these are all the mismatches, i.e. industries that are not in the shorter list
Industry | Sub-Industry | Sub-Sub-Industry |
DDD | BBB | FFF |
XXX | YYY | ZZZ |
OOO | PPP | QQQ |
<tbody>
</tbody>
Thanks for your help!