Create Excel Macro
$30-250 USD
Paid on delivery
Need someone who's really good with Excel macros to create something for me. We currently have writers submitting large amounts of blog posts to us in csv files, and we need a macro to automatically place a link inside the content.
Here's the format (simplified version, actual fields are a little different):
Column A: keyword phrase
Column B: url
Column C: post title
Column D: blog post
The macro needs to scan column D and find the first occurrence of the keyword given in column B. If found, it needs to replace the keyword with the following:
< a href=" (url found in column B)" > (keyword in column B) < /a >
(that's not proper html code, but you get the idea)
This should only be replaced on the FIRST occurrence of the keyword.
So, for example, if the kw is "dog food", the url in column B is [login to view URL], and the first sentence of the blog post is "My dog really likes Wellness dog food much better than the Purina dog food that he used to eat." - the macro would change that to be:
"My dog really likes Wellness <a href="[login to view URL]" >dog food</a> much better than the Purina dog food that he used to eat."
Notice that the kw "dog food" happened twice in that sentence, and only the FIRST occurrence was replaced.
I'm attaching the exact data file that you'd need to work on. The keyword is in column AB, the URL is in column AC, the post title is in AD, and the blog post is in AE.
You can have the macro either replace the content in AE, or add a new field in AH.
Maximum budget is $50, paid when I have a working macro.
Project ID: #1328268
About the project
29 freelancers are bidding on average $40 for this job
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering usual Open file dialog to identify the current inpu More
Hello - My bid is for an Excel VBA macro that will insert links as required. Payment upon completion is OK, but I would require the funds in escrow. Thank you. Chandra Ram
Creating Macro's is one of ours main specialties. This task can be done in 1 day. Regards K&C
Hi, Completed the work for you. Please find attached the samplefile with macro which will do all the work you explained. Macro will fill the column 'AH' in the samplebatch file Check macro from your end and let More
Hi sir! I understand what you need - it can be done by macro or by formula, whatever you like. Fast and accurate! (I'm just not sure the attachment is right?) I hope we will cooperate. Thanks!
Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi More
Hi, I have enough experience in VBA Macros and Excel. I will be able to deliver this on time. Cheers mightybichu