Find Jobs
Hire Freelancers

Create Excel Macro

$30-250 USD

Закрито
Опублікований over 12 years ago

$30-250 USD

Оплачується при отриманні
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.
ID проекту: 1328268

Про проект

29 пропозицій(-ї)
Дистанційний проект
Активність 12 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
29 фрілансерів(-и) готові виконати цю роботу у середньому за $40 USD
Аватарка користувача
I have formula for this instead of micro.
$30 USD за 1 день
5,0 (279 відгуки(-ів))
7,9
7,9
Аватарка користувача
Excel Whiz here ;) Less than an 30 mins job for me :) Please see PMB for more details.
$30 USD за 0 день
4,9 (149 відгуки(-ів))
6,5
6,5
Аватарка користувача
I am an Excel expert. I can create an easy-to-use template for this.
$30 USD за 1 день
5,0 (148 відгуки(-ів))
6,4
6,4
Аватарка користувача
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 input file. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!
$40 USD за 1 день
4,9 (64 відгуки(-ів))
5,7
5,7
Аватарка користувача
Macro expert - ten years experience.
$50 USD за 1 день
4,9 (32 відгуки(-ів))
5,6
5,6
Аватарка користувача
Hi, I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me after successful project delivey. Please see my private message(PM) and sample projects attached with PM for reference. Regards Fibin
$30 USD за 0 день
4,9 (50 відгуки(-ів))
5,3
5,3
Аватарка користувача
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
$50 USD за 1 день
4,5 (17 відгуки(-ів))
5,4
5,4
Аватарка користувача
Hi Sir, Please check your inbox.
$35 USD за 2 дні(-в)
5,0 (25 відгуки(-ів))
5,0
5,0
Аватарка користувача
Creating Macro's is one of ours main specialties. This task can be done in 1 day. Regards K&C
$30 USD за 0 день
4,9 (21 відгуки(-ів))
5,0
5,0
Аватарка користувача
Hi I am an experienced Excel Macro(VBA) developer having expertise in Smart solution development. I can create an amazing tool which will perform your specified task and create that html code. Please check my feedback scores and reviews. I am sure you will be my next satisfied client. If you have any question, please don't hesitate to ask. Hope to hear from you soon. Thanks Best Regards 3dwOrX
$50 USD за 1 день
5,0 (20 відгуки(-ів))
4,7
4,7
Аватарка користувача
I have done it. Please see PM.
$35 USD за 1 день
5,0 (27 відгуки(-ів))
4,8
4,8
Аватарка користувача
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 me know for any other changes Thanks Naveen
$50 USD за 1 день
4,8 (23 відгуки(-ів))
4,6
4,6
Аватарка користувача
Please see your Pm.
$100 USD за 2 дні(-в)
5,0 (10 відгуки(-ів))
4,2
4,2
Аватарка користувача
The macro is ready.. Please see sample in PM..
$35 USD за 0 день
4,9 (27 відгуки(-ів))
4,3
4,3
Аватарка користувача
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!
$30 USD за 0 день
5,0 (16 відгуки(-ів))
4,2
4,2
Аватарка користувача
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 copies if you so desire. U can expect quality work in time. Thanks
$50 USD за 2 дні(-в)
4,9 (6 відгуки(-ів))
3,3
3,3
Аватарка користувача
Hello, i will deliver it as soon as you pick me.
$30 USD за 0 день
5,0 (3 відгуки(-ів))
2,0
2,0
Аватарка користувача
Hi, I am interested in this job posting. Please check PMB. Thanks
$40 USD за 1 день
5,0 (3 відгуки(-ів))
1,4
1,4
Аватарка користувача
Hi, I have enough experience in VBA Macros and Excel. I will be able to deliver this on time. Cheers mightybichu
$40 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
i need one day to research the macro, and another day to finish the goal.
$60 USD за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
Philadelphia, United States
5,0
2
Спосіб оплати верифіковано
На сайті з черв. 11, 2011

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.