I have a two part problem in comparing lists of email addresses. The first should be simple enough: in the C column of one sheet, the addresses are in the format "<name@domain.com>", and I'll need a way to remove the <>'s so that I can compare the list with another one.
The second part seems to come up a bit, most recently addressed by a response by HalfAce to msavage. I tried to use the code HalfAce posted, but the For statement kept giving me a compile error ("Expected: expression"). Here are the specifics to the problem: two worksheets in a book, rows in each are First Name, Last Name, email. I need to compare the entries, and create a third sheet from the rows in Sheet A which are not in Sheet B, using the email add's as the criterium. Any help out there?
The second part seems to come up a bit, most recently addressed by a response by HalfAce to msavage. I tried to use the code HalfAce posted, but the For statement kept giving me a compile error ("Expected: expression"). Here are the specifics to the problem: two worksheets in a book, rows in each are First Name, Last Name, email. I need to compare the entries, and create a third sheet from the rows in Sheet A which are not in Sheet B, using the email add's as the criterium. Any help out there?