Develop Excel Macro - Filter duplicates, negative keywords

$10-30 USD

Completed

Posted

about 6 years ago

$10-30 USD

Paid on delivery

I am looking for someone to build an Excel Macro. The Macro will take upto 5 csv files. It will take a particular column from the csv files, combine into one and remove all duplicates. This is a list of words. I want option to be able to filter out based on word count (from 1-8 words in row) Macro should have option to put in a list of words that should also be filtered. I.e. I can put in a list of words that if it contains, it should filter out any rows containing those words as well. This Macro will be used to process lists of keywords so I am looking to remove duplicates and negative keywords. Please list "I know VBA" in your proposal.

Visual Basic for Apps

Project ID: 16292876

About the project

9 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done many similar projects in the past without a single problem. Ok, not to forget to mention: "I know VBA". Anyway i would like to go over this steps, for example do all 5 csvs have the same structure (column in the same place) ... If you are interested in working with me feel free to message me. Thanks, Milan

$30 USD in 0 day

5.0

(414 reviews)

6.8

9 freelancers are bidding on average $33 USD for this job

@KulfiSoftwares

I know VBA; can write a macro to combine sheets, then remove duplicates, and negative words. ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.

$50 USD in 2 days

5.0

(307 reviews)

7.5

@P0L

I know VBA and I'm interested in your project. Please send me a message so that we can discuss more.

$30 USD in 1 day

4.9

(280 reviews)

7.2

@vaidyag

Hi, This is easily doable. I have one question: Do you want to specify the location of the file or you want the macro to pick up files from a folder? (in this case we need to sure there are only the required files in the folder). Also can you please share sample CSV files to do this? Regards Vaidy

$25 USD in 1 day

5.0

(15 reviews)

5.2

@rinabuoy13

Hello friend, I am well versed in excel. I can help you with this. Looking to hearing from you. Kind regards I know vba

$30 USD in 1 day

4.9

(51 reviews)

5.4

@supper5guy

I know VBA Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do the best job in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Thanks

$25 USD in 1 day

4.9

(71 reviews)

5.3

@nurnga1218

I Know VBA, and I did many VBA projects here. As your project brief, I think I can start working after you send me your files. I hope we'll discuss further. Thanks

$25 USD in 1 day

5.0

(41 reviews)

4.5

@ongskjason

I know VBA

$30 USD in 1 day

5.0

(6 reviews)

3.7

@mkoteshwar

I know VBA. I just have one question - will all the CSV files to be processed be in a specific folder ? Or would you want to select each file separately?

$55 USD in 3 days