My goal is to compare two worksheets and identity data that is not present in both and label each record as such. Essentially, I need to compare transaction numbers from a column of data in worksheet A against a column of data in worksheet B and identify which records are not present in worksheet B.
Can anyone suggest a solution?
Bookmarks