Find Jobs
Hire Freelancers

Auto Fill in a Spreadsheet with Data by VBA

$10-30 USD

完了済み
投稿日: 7年以上前

$10-30 USD

完了時にお支払い
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.
プロジェクト ID: 12307971

プロジェクトについて

17個の提案
リモートプロジェクト
アクティブ 7年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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 0日以内
5.0 (200 レビュー)
5.9
5.9
この仕事に17人のフリーランサーが、平均$26 USDで入札しています
ユーザーアバター
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 1日以内
4.8 (104 レビュー)
6.1
6.1
ユーザーアバター
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 2日以内
4.6 (90 レビュー)
6.1
6.1
ユーザーアバター
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 1日以内
4.8 (53 レビュー)
4.9
4.9
ユーザーアバター
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 1日以内
4.9 (36 レビュー)
4.8
4.8
ユーザーアバター
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 1日以内
5.0 (7 レビュー)
2.8
2.8
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
$35 USD 15日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
good listening
$30 USD 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
$25 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
$25 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 5日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 1日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
sugar land, United States
5.0
9
お支払い方法確認済み
メンバー登録日:10月 26, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。