In Progress

excel database management / administration

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.

Skills: Database Administration, Excel, Microsoft Access

See more: database management excel, microsoft excel management, microsoft access administration, mail merge macro, excel source, excel mail merge macro, microsoft macro, microsoft excel mail merge, source database, excel function, excel duplicate, develop database, database management, database remove duplicates, excel filter function, excel filter list, excel macro develop, duplicates excel, microsoft merge, macro merge rows, file filter excel, excel function filter, excel data management, excel macro merge rows, excel macro reference

About the Employer:
( 1 review ) Bayside, United States

Project ID: #2535669

Awarded to:

hfarida

I have good excel VBA experience. I have built efficient tools on Excel VBA. I can do this job for you.

$40 USD in 1 day
(1 Review)
1.4

23 freelancers are bidding on average $72 for this job

mrbrave

Lets start now....I have over 7 years of Excel VBA experience.....Can do this in few hours..

$40 USD in 1 day
(73 Reviews)
5.3
bouslimi1979

Please check PM. Thanks

$80 USD in 3 days
(31 Reviews)
5.3
winnet21

Hi, I have experience with this project. Please check PM. Thanks

$110 USD in 1 day
(11 Reviews)
4.7
srinichal

I can deliver the Macro

$250 USD in 12 days
(3 Reviews)
4.6
ExactSystems

Please see a solution on PMB.

$150 USD in 3 days
(4 Reviews)
4.5
naveenvarthaan

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

$35 USD in 1 day
(13 Reviews)
4.2
Engineer85

Hi I am an Engineer and Excel professional. I can handle this job for you with accuracy. Thanks

$60 USD in 1 day
(10 Reviews)
4.2
FLtowhid

Please see my PM.

$30 USD in 4 days
(4 Reviews)
3.8
manisankarmani

Belfast, UK based developer. Already have done many similar project of various clients.

$40 USD in 2 days
(9 Reviews)
3.3
AdamT82

Dear dsjkang, I would like to inform you, that I have already finished your project and I have sent you ready file to check. I have based on information and data, that you were prepared. Please, try it yourself and More

$50 USD in 2 days
(1 Review)
2.6
xcruc1at3r

with having Excel Macro experience & i have already done similar kind of work and i can provide the macro and provide you easy excess & automated macro for cleanup purpose. we can further discuss the procedure of datab More

$45 USD in 3 days
(0 Reviews)
0.0
frankwanyiri

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

$200 USD in 1 day
(0 Reviews)
0.0
Saurabhdhoot123

Expert in Excel! Having 7 year experience

$30 USD in 2 days
(0 Reviews)
0.0
sudhansus

i want to do

$30 USD in 2 days
(0 Reviews)
0.0
moeedarif

we can do it,pls choose us.

$50 USD in 2 days
(0 Reviews)
0.0
iOne11

High quality output with cheap rate.

$35 USD in 4 days
(0 Reviews)
0.0
dataprocessing1

Hi, Please see your PMB.

$30 USD in 1 day
(0 Reviews)
0.0
nayomi276

I am expert for this job.

$100 USD in 3 days
(0 Reviews)
0.0
Shiva0691

have good experience in Ms Excel.Do not have any other job in my hand.Shall finish assignment on time

$45 USD in 2 days
(0 Reviews)
0.0
vikasbhatnagar

Please see my email in your mail box and discuss this in more detail if you find it interesting. Thanks.

$100 USD in 1 day
(0 Reviews)
0.0