I need a way to compare two spreadsheets in a workbook, find the differences, then write those differences on the spreadsheet in sequential order in the same column below the existing numbers.
Sheet1 has participating dealer numbers. All dealer numbers are listed in Column C beginning in cell 5. All dealers participating fill in downward. (note: these dealers are listed in a District Order so some of the cells will have the word TOTAL in it instead of a dealer number) Column B hosts the District Letter. I also need to carry over this letter as well.
"Sheet1":
A 207475
A 207775
B TOTAL
In Sheet2 I have listed the complete list of Dealers to compare against.
"Sheet2":
A 206600
A 207475
B 206624
I would like for my missing dealers to show below a section I have set up as missing dealers like the below example: (ignoring the District Totals) (yet capturing the District letter in Column B as well)
MISSING DLRS.
A 207775
A 206600
B 206624