Hi,
In a excel file there are some sheets. Each sheet contain Mail id column/columns. If Mail id repeated in all sheets / with in the sheet / some sheets, after running macro, all duplicate mail id's should be deleted. only unique mail id's should be remained.
Thank you in advance.
Last edited by ajaypal.sp; 03-27-2015 at 02:57 PM. Reason: Attachment missing
can you upload a desensitized sample of your data with an additional tab(s) showing your desired result?
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Please find the attachment (1st Post).
still kinda tough to discern what you're asking for, but this code searches through every used cell in every worksheet for a "valid" email address (code for IsEmailValid found here: http://www.vbaexpress.com/kb/getarticle.php?kb_id=281 , commented out several of the validation checks since your emails appear to all have a "," at the end making them invalid...) and if it is valid, searches through column A of Sheet1 to try to find it. Assuming that address is not found, it is added to the end of column A in Sheet1. End result was 7,281 unique email addresses listed in Column A of Sheet1.
As in the attached.
Please Login or Register to view this content.
For future reference, it is probably better to use fake data - make up fake email addresses etc... these look like real people and they may not appreciate your having provided their addresses for all the world to see.
Last edited by simarui; 03-30-2015 at 11:34 AM.
Thank you very much Mr. Simarui.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks