In an Excel worksheet database, I need to filter out unnecessary and duplicate data. The purpose is to format each month's new database into a source for mail merge for marketing purposes. Each month, the criteria of unnecessary and duplicate data will grow, so we need to develop an automated way to filter our unwanted entries. Preferably, we wish to perform this procedure in excel through a series of simple steps. We can manually enter the specific criteria each month to perform this function if necessary.
We wish to develop a macro or any automated process to perform the following on the Excel database:
1. Remove rows containing certain keywords in specific columns.
2. Remove rows that are duplicates of specific criteria in specific columns. For example, two rows may contain different data in columns A and B, but contain identical data in columns C and D. We wish to remove one of the rows that is a duplicate containing the identical data in columns C and D. We wish to be able to specify the criteria in these columns.
3. All removed rows should be segregated into a separate worksheet or file, or be moved to the bottom of the same worksheet.
Attached file is partial list for reference only. Private and Confidential.
23 freelancers are bidding on average $72 for this job
Hi dsjkang, I Completed your project. THE BEST DUPLICATE ROWS REMOVER just for 35$. Try the file which i have sent you. You would certainly like it. Best Regards, Naveen
Hi. I will deliver your work within 20 hours, but before that, after 12 hours, I will deliver a copy of the completed. I am very efficient in database design and management. Thank you