Create an simple Excel Macro to add keywords to a word list

This macro must be compatible with Microsoft Excel 2010. A PDF of the full instructions, with images is attached, and the instructions are below in text.

In sheet 1, I will place category headers in the first row and word lists beneath them.

In sheet 2, I will place a word list in column A.

1. When the macro runs, it will take the word in Sheet 2, Column A, Row 1, and search to see if it appears in any of the lists on Sheet 1.

2. If it does not find the word in sheet 1, it will repeat the step for the word in the next row of Sheet 2, Column A until it finds a match.

3. If none of the words in Sheet 2, Column A match any of the words in Sheet 1, end the macro. If not, go to the next step.

4. If it finds the word in sheet 1, I will copy the category for that name (which will be in row 1 of the column).

5. Then it will paste the category name into the next available column next to the word in Sheet 2

6.. After all the words in sheet 2 have been labeled, replace any blank cells in sheet 2 with “*[Column Letter]*”

Do this for all columns that contain a word, but if there is no word in the column, stop.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: simple excel macro add data form, excel vba add page word, excel macro vba import csv text file, excel macro select internet explorer, excel macro select contents ctrl, excel macro search text word doc lines, excel macro find text word file, excel macro add internet explorer favorite, create form excel macro vba, create excel macro projects online, create excel macro log account website, create excel macro internet, create excel macro find, create excel macro run powershell script, create subdirectories excel macro, powershell create excel macro, create simple print macro excel, excel macro move rows need speed process, excel macro browse folder import files list, excel macro copy cell next cell list

About the Employer:
( 17 reviews ) Henderson, United States

Project ID: #15592169

Awarded to:


Hi, I am experienced VBA developer with over 7 years of professional experience. I am available to work on the macro right now. I can complete the macro within couple of hours. Lets start. Thanks

$50 USD in 1 day
(246 Reviews)

21 freelancers are bidding on average $99 for this job


Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros (VBA)) and i've never had a single problem. If you are interested p More

$35 USD in 0 days
(416 Reviews)

Hello? Plz check my reviews. I have good skills in excel vba and macros. So i can help you if you need. I will never disappoint you. I have developed loan system. So i will provide good result. Thanks.

$155 USD in 3 days
(59 Reviews)

p.s. Mainly here need SQL/ado coding Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career befor More

$155 USD in 3 days
(32 Reviews)

Hi, I have gone through your project details on macro creation on microsoft excel and can help you quickly on it to get it done as per your need. I have worked on several macro related projects and completed successfu More

$83 USD in 3 days
(97 Reviews)

Hi, I am good with VBA (Macro) development and done a few projects. I reviewed the project requirements and will be able to complete the project in 3 days. Please feel free to contact so that we can discuss the p More

$150 USD in 3 days
(28 Reviews)

Hi, I am interested in discussing this task. In the job post, I am able to see only the image file. If you could share the PDF file, it would be great. From the description of job posted, I feel that I will be able More

$50 USD in 1 day
(35 Reviews)

Hi, I'm not entirely sure about the details of your instructions (I'd need them clarifying) - but what you're asking is relatively straightforward. There's a much simpler way to do this with PHP rather than usi More

$66 USD in 0 days
(7 Reviews)

Hi, I'm willing to do this without being awarded, just to take the risk of selecting an unknown freelancer out of you. Just need the word GO through chat, I'll start right now, keep you posted, I'll have this done i More

$100 USD in 1 day
(10 Reviews)

Bidding minimum to win. I have sound knowledge in macros and would be able to complete the task on time. Looking forward to work with you.

$35 USD in 2 days
(3 Reviews)
$111 USD in 10 days
(0 Reviews)
$44 USD in 3 days
(0 Reviews)

I am currently double majoring in computer science and finance at my college where I take calculus and statistics. My passion for computer programming was sparked at age 12 when I taught myself too make video games. I More

$45 USD in 3 days
(0 Reviews)

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)

A proposal has not yet been provided

$45 USD in 1 day
(0 Reviews)

Hi there Hello, I'm interested in your project. i have experience data entry since 3 years Please know more ls in chat. Thanks

$155 USD in 3 days
(0 Reviews)

A proposal has not yet been provided

$222 USD in 15 days
(0 Reviews)

I am interested on your job. I belive i am fit for this work. please check my portfolio as a prove. Check my profile discription to allow me for your work.

$133 USD in 3 days
(2 Reviews)

Hello, I can do this job ///////////////////////////////////////////////////////////////////////////

$35 USD in 3 days
(0 Reviews)

Hi there, What you are asking for is pretty straightforward. The macro needs to work as a vlookup with an if statement and a find and replace imbedded. Looking forward to helping you out! Jan

$100 USD in 3 days
(0 Reviews)

helloo sir I have one year experience in data entry . I.m better then other. U will hire me.i will give u my best Thanks Relevant Skills and Experience Data entry ..excel

$155 USD in 3 days
(0 Reviews)