Create an simple Excel Macro to add keywords to a word list
$30-250 USD
Completed
Posted about 6 years ago
$30-250 USD
Paid on delivery
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.
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
4.9 (282 reviews)
6.8
6.8
19 freelancers are bidding on average $99 USD 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 please share the full PDF specification with sample file as shown on the picture.
Usually i can automate comparisons between few sheets like this one in matter of hours.
Thanks, Milan
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.
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 in less than 4 hours, I'll show it to you, then you award me, at any point you can select any other bidder, no questions ansked
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 successfully.
Waiting for your response for further discussion in detail to start the work. Thanks.
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 to get this done. Would like to see the PDF to confirm the exact requirement.
Looking forward to hear from you.
Best Regards,
Akila.K
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 before.
I am senior Access/SQL/VB /Excel developer since 1997 and I can write for you a user-friendly program using MS Excel .
I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work.
Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details.
Thank You and Regards,
Zura
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 using VB - did you choose VB just to get access to VBA or do you really want this done in VBA?
Either way, it should be doable within a couple of hours.
Thanks a lot,
John
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
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.
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