Find Jobs
Hire Freelancers

Auto Fill in a Spreadsheet with Data by VBA

$10-30 USD

Completed
Posted over 7 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 12307971

About the project

17 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

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:
User Avatar
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 day
5.0 (200 reviews)
5.9
5.9
17 freelancers are bidding on average $26 USD for this job
User Avatar
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 day
4.8 (104 reviews)
6.1
6.1
User Avatar
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 days
4.6 (90 reviews)
6.1
6.1
User Avatar
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 day
4.8 (53 reviews)
4.9
4.9
User Avatar
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 day
4.9 (36 reviews)
4.8
4.8
User Avatar
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 day
5.0 (7 reviews)
2.8
2.8
User Avatar
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 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
good listening
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
sugar land, United States
5.0
9
Payment method verified
Member since Oct 26, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.