I have two Excel lists. One master list (list A) contains all our email addresses from our customers. The other list (list B) contains a list of people who do NOT want to recieve emails. How do I take the emails from list B (there are 1,200 of them) and compare them automatically to list A? Basically if any email address from list B appears in list A, I want it to delete in list A.
is that possible?
thank you
Hello jspinx,
Are these lists on the same worksheet? If so, do the lists share any rows?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Leith
they are on different files. Each entry is a different row
Hello jspinx,
Good, that makes life much easier. I'll start coding the macro.
Hello jspinx,
This will remove the emails on the Master list that appear on the Do Not Email list. You can change the list location and starting cells (marked in red) to match what you are using.
Please Login or Register to view this content.
wow thanks a lot!
Try using the compare2lists freeware found at the following address: http://sites.google.com/site/compare2lists/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks