Comparing email strings

[kerabek]

hi guys,
sorry if double posting, didn't manage to find the answer with the search engine....

here's the deal:

tableA and tableB have emails in the first column.

macro should calm the tableA row by row and each time check in tableB if there is a same string (email) case insensitive.
if there is no such email address - append it to the first empty row in tableB (or the last active cell + 1 row)

thank you in advance!!!!

 

[StuLux]

If using Excel 2007-2010 why not just filter column A for unique values and then the list you are left with would be all the unique email addresses?

 

[kerabek]

excel 2003 ...

 

[VoG]

Then Advanced Filter http://www.contextures.com/xladvfilter01.html#FilterUR

 

[kerabek]

Thank you so much!!!!