Auto Fill in a Spreadsheet with Data by VBA

$10-30 USD

Completato

Pubblicato

più di 7 anni fa

$10-30 USD

Pagato al completamento

Please use VBA to write the code. I have a few categories of key words(say 5 categories (category A-E) with around 10 key words in each category) in a spreadsheet, if i manually paste text into a column (say B1 in column B), I want the code to find if one of the key words in category A is in B1. If so, then set the key word as the value of C1; if none or more than 1 key words from category A are found in B1, then set C1 as blank and filled with red. Do the same thing to category B, and set the key word found to D1. and so on and so forth, until all the categories are scanned to finish the row. The categories will be defined by lists in a separated sheet in the same book. The code should allow me change the key words (add, remove, edit) in each category and the categories (add, remove, edit) as well.

Data Entry

Excel

Visual Basic

Rif. progetto: 12307971

Info sul progetto

17 proposte

Progetto a distanza

Attivo 7 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato a:

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel jobs (both with formulas and macros) and i've never had a single problem. If you are interested please send me sample file (with keywords sheet). As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan

$21 USD in 0 giorno

5,0

(200 valutazioni)

5,9

17 freelance hanno fatto un'offerta media di $26 USD

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

$30 USD in 1 giorno

4,8

(104 valutazioni)

6,1

@sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards

$29 USD in 2 giorni

4,6

(90 valutazioni)

6,1

@vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating strings and creating reports with specific conditions. I have also expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra

$30 USD in 1 giorno

4,8

(53 valutazioni)

4,9

@ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. . I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi

$30 USD in 1 giorno

4,9

(36 valutazioni)

4,8

@huypq5

As description in your requirement. I'm sure to complete this tool for you. inbox me if you have any question about my skill or this project. Thank for your attention HuyPQ.

$25 USD in 1 giorno

5,0

(7 valutazioni)

2,8

@trn6484

Hello, Let me introduce as a hard working data entry professional,willing to go that extra mile to achieve the targets set forth.I saw your project.I want to work with you. I have sound English skills and proficiency in e-commerce site navigation. I would be the right candidate for the current position. Awaiting an affirmative response from you. Thanks and Regards, Tanvir Rahman.

$23 USD in 1 giorno

0,0

(0 valutazioni)

0,0

@sabbirhossainbd

A proposal has not yet been provided

$35 USD in 15 giorni

0,0

(0 valutazioni)

0,0

@LOVELYDINESH

good listening

$30 USD in 7 giorni

0,0

(0 valutazioni)

0,0

@ahmedtaher2020

A proposal has not yet been provided

$25 USD in 1 giorno

0,0

(0 valutazioni)

0,0

@jayApao

A proposal has not yet been provided

$25 USD in 1 giorno

0,0

(0 valutazioni)

0,0

@hasnibinomar

Greetings, I am Hasni from Kuala Lumpur. I am interested to work on your project. I understand your specifications and have some ideas on how best to produce the spreadsheet for you. Thank you Best regards, Hasni Omar

$30 USD in 5 giorni

0,0

(0 valutazioni)

0,0

@fabianomg

estou qualificado para realizar essa tarefa pois já trabalho a muito tempo com VBA e macros no Excel estou disposto a realizar o serviço o mais breve possível.

$23 USD in 1 giorno