Identify The Errors, Duplicates, Typos And Such Between Two Spreadsheets Of Over 4000 Rows Of Data Each

I need to identify the errors, duplicates, typos and such between two spreadsheets of over 4000 rows of data each. The Macro: I got a macro working, but it's not perfect. So far, it can only tell data that's missing on spreadsheets A, or B. However, it can't tell which are the duplicates, typos, etc. Please look at the sample for more details. The code is included in the sample. And for your convenience, it's right here:

Sub difference_general()
Dim frontcount As Long
Dim backcount As Long
Dim diffcount As Long
Dim nosrcflg As Boolean
Dim front_ref As String
Dim back_ref As String
Dim anydiffflg As Boolean
Dim ftnotexistflg As Boolean
Dim invnotexistflg As Boolean
Application. ScreenUpdating = False
Application.Calculation = xlCalculationManual
Sheets("Diff").Select
Cells(1, 1).Select
Rows("2:65536").Select
Selection.Delete Shift:=xlUp
Cells(1, 2).Select............................