Auto Fill in a Spreadsheet with Data by VBA

$10-30 USD

Dokončeno

Zveřejněno

před více než 7 roky

$10-30 USD

Zaplaceno při doručení

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

IČ projektu: 12307971

O projektu

17 nabídky

Vzdálený projekt

Aktivní před 7 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 0 dni

5,0

(200 recenze)

5,9

17 freelanceři nabízejí v průměru $26 USD za tuto práci

@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 v 1 dni

4,8

(104 recenze)

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 v 2 dnech

4,6

(90 recenze)

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 v 1 dni

4,8

(53 recenze)

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 v 1 dni

4,9

(36 recenze)

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 v 1 dni

5,0

(7 recenze)

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 v 1 dni

0,0

(0 recenze)

0,0

@sabbirhossainbd

A proposal has not yet been provided

$35 USD v 15 dnech

0,0

(0 recenze)

0,0

@LOVELYDINESH

good listening

$30 USD v 7 dnech

0,0

(0 recenze)

0,0

@ahmedtaher2020

A proposal has not yet been provided

$25 USD v 1 dni

0,0

(0 recenze)

0,0

@jayApao

A proposal has not yet been provided

$25 USD v 1 dni

0,0

(0 recenze)

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 v 5 dnech

0,0

(0 recenze)

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 v 1 dni