Make an excel for Mac macro

Need somebody to make a Excel for mac macro. Attached is the sample input file.

For any spreadsheet with data in this format, we need columns sorted in following order:

First Name

Last name

Org Short Name






Matching Org

Matching School

Snippet 1

Snippet 2

Snippet 3

<all other columns follow>

The width of the columns should be set to what I sent. The following columns are new or need some programming:

Org Short Name: this should be exact copy of "Organization 1" column, but if the name of the org ends with ", Inc" or ",Inc" or ",inc." or any variant, then the "Inc." (or similar variant ) text should be deleted.


Need to use Linkedin API or website scrape to find the company website (domain), given the linkedin company profile link (which is one of the columns in this spreadsheet). For example for [login to view URL], the website domain in this column would be : [login to view URL]

If LinkedIn fails then we can use a public API called clearbit (easier).


We need to use the [login to view URL] API to pull in the email address:

[login to view URL]

If the sheet already has an email populated, then do not replace it with the API provided email


Use this API :

[login to view URL]

fill in the value: success, unknown , fail

rows should be sorted such that success are on top and fail on bottom.


Insert a blank column with single character width (this will be manually filled in)

Matching Org:

If any of the orgs Organization 1 through Organization 7 match the following text (case insensitive): IDT




Then put the name of the orgs and in parenthesis put the start date and end date ("Organization Start" and "Organization End" like this:

IBM (4/93-5/96); Nationwide(8/97-10/01)

The list of organizations above should be editable.

Matching School:

Similar to matching org. If any of Education 1 through 7 match the following:


ABC High School

Then put the name of the schools and start and end years

Snippet 1: this should be empty and same width as 'Title'

Snippet 2 this should be empty and same width as 'Title'

Snippet 3: this should be empty and same width as 'Title'

If I run the macro again, it should give me option to either overwrite existing data or keep existing data. I may also need to manually make corrections to "domain" field from the data that's pulled in API. Then based on this data the emails should be updated. There should also be some sort of progress indicator as rows are being processed.

Квалификация: Excel, Excel VBA, Веб-скрейпинг

Показать больше excel 2000 macro web, convert excel 2000 macro excel 2007 macro, excel comparing macro code, developer tab excel mac, how to enable macros in excel mac 2008, excel macros mac not working, developer tab excel mac 2017, macros in excel for mac 2011, vba excel mac 2016 tutorial, how to enable macros in excel mac 2016, how to enable macros in excel mac 2011, excel vba macro paste adjacent column, data excel sheet macro, excel project macro samples, paste excel vba macro, excel vba macro databases, open office calc macro java example, calculation sheets different excel files macro, excel internet macro example, setting macro excel mac

О работодателе:
( 8 отзыв(-а, -ов) ) New York, United States

ID проекта: #19349503

20 фрилансеров(-а) в среднем готовы выполнить эту работу за $144


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Больше

$250 USD за 3 дней(-я)
(683 отзывов(-а))

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Больше

$250 USD за 4 дней(-я)
(304 отзывов(-а))

This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l Больше

$150 USD за 3 дней(-я)
(95 отзывов(-а))

Hi, I am experienced on Microsoft Access , Excel and VBA, Powerpoint. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

$200 USD за 3 дней(-я)
(142 отзывов(-а))

Hi, I am excel and vba expert, I can do it for you. Mohsan

$250 USD за 3 дней(-я)
(79 отзывов(-а))

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you Больше

$194 USD за 3 дней(-я)
(57 отзывов(-а))

Hello sir. VBA scripting on MAC is really different than Windows version, especially for jobs like this. Because XMLHTTPrequest which is the must-have VBA function to make api calls will NOT work in Mac version, of co Больше

$200 USD за 10 дней(-я)
(46 отзывов(-а))

Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. I will complete this task with your timeline and [login to view URL] give me a chance to serve Больше

$30 USD за 1 день
(67 отзывов(-а))

"Hi, I looked at your description carefully and I am very interested in providing my skills in hopes of working with you. I have ample experience in web scraping. -scrap any website using selenium, beautifulSoup, requ Больше

$150 USD за 3 дней(-я)
(12 отзывов(-а))

Hello Sir, I have great experience in macro I am professional developers with having more than 5 year's experience in this field. I read your project description and I am interested in it I have need some more info Больше

$150 USD за 5 дней(-я)
(6 отзывов(-а))

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Больше

$61 USD за 0 дней(-я)
(36 отзывов(-а))

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Больше

$100 USD за 2 дней(-я)
(22 отзывов(-а))

How are you? Dear. I have just read your job post. Indeed, very interesting. So I think both of us could discuss details about this project with each other via chatting. Look forward to you. Thanks a lot. :)

$111 USD за 3 дней(-я)
(5 отзывов(-а))

GO WITH SCIENCE AND EXPERIENCE. I'm a Master holder in computer science. FOR JUST 30 Euros and in JUST ONE DAY from awarding the project, it will be delivered to you in a HIGHER quality than expected. I'm an expert in Больше

$30 USD за 1 день
(1 отзыв)

I Will Do Data Entry,Data Analysis,Data Mining,Internet Research I specialize in : ? Offline and Online Data Entry ? Data Mining ? Data Analysis ? Copy Paste Task ? Data Capturing From Any Website ? G Больше

$250 USD за 3 дней(-я)
(1 отзыв)

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of Больше

$166 USD за 3 дней(-я)
(0 отзывов(-а))

Hello. I have read your description carefully. It's very interesting for me. I have rich experience for 12+ years on skills that you want. So I think I can help you with my ability. I am a full-time freelancer a Больше

$30 USD за 3 дней(-я)
(0 отзывов(-а))

Hello There, I have understood the task and I can help you out with the task. I have more than 5 years of experience in handling these kind of task. Can we discuss more about this in IB? I am ready to provide Больше

$60 USD за 3 дней(-я)
(0 отзывов(-а))

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do Больше

$208 USD за 7 дней(-я)
(0 отзывов(-а))

First time I'm seeing a post like this. Everything is just so clear. Yes I'm telling you that I have no experience. But trust me, Your helping hand can make me do this. Please be kind to me. I'll do it for you at a che Больше

$30 USD за 3 дней(-я)
(0 отзывов(-а))