compare 2 different excel sheets and output results on 3rd sheet using VBA

[sunwave]

Using VBA

I want to compare the email addresses on sheet1 to sheet 2 and output the results on sheet 3.

Sheet 1 and Sheet 2 have most of the same email addresses with a few extras (different addresses) on each.
There are extra email addresses on sheet 1 but are not on sheet 2.
There are extra email addresses on sheet 2 but are not on sheet 1. (Vice versa)

The results:
I want the results to output the email addresses from sheet 1, that are missing from sheet 2, labeled as "Not in Sheet 2"
I want the results to output the email addresses from sheet 2, that are missing from sheet 1, labeled as "Not in sheet 1" (Vice Versa)
The results from both sheets should output on Sheet 3.


How would I code this? Thank you!!

[thomglea]

Please Login or Register  to view this content.

[jindon]

1) Formula

Sheet3
A2:
=FILTER(Sheet2!D:D,(Sheet2!D:D<>"")*(ISERROR(MATCH(Sheet2!D:D,Sheet1!B:B,0))))
B2:
=FILTER(Sheet1!B:B,(Sheet1!B:B<>"")*(ISERROR(MATCH(Sheet1!B:B,Sheet2!D:D,0))))

2) vba

Please Login or Register  to view this content.

[mjr veverka]

... and one more "something":

Please Login or Register  to view this content.

[AliGW]

The screenshots have been removed for now as they appear to contain sensitive personal data that should never be shared in a public online community such as this. Please dezensitise before sharing again

[sunwave]

This is perfect. Thank you!!!!!!!!!!!

[sunwave]

I made those names and emails up. I will disclose that next time!

[AliGW]

Indeed! I was just trying to protect you (and them).