Suljettu

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

Domain

Email

Title

Include

Location

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.

Domain:

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).

Email:

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

Bulkemailcheck:

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.

Include:

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

IBM

Accenture

Microsoft

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:

Cornell

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.

Taidot: Excel, Excel VBA, Tietojen kaavinta verkosta

Näytä lisää: 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

Tietoa työnantajasta:
( 8 arvostelua ) New York, United States

Projektin tunnus: #19349503

20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

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 ( Lisää

$250 USD 3 päivässä
(683 arvostelua)
8.4
schoudhary1553

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. Lisää

$250 USD 4 päivässä
(304 arvostelua)
7.8
polarjin2017

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 Lisää

$150 USD 3 päivässä
(95 arvostelua)
6.7
fatimatuzzohura

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 päivässä
(142 arvostelua)
6.3
MohsanEijaz

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

$250 USD 3 päivässä
(79 arvostelua)
6.2
sonarkaushik

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 Lisää

$194 USD 3 päivässä
(57 arvostelua)
5.8
ilkecokay

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 Lisää

$200 USD 10 päivässä
(46 arvostelua)
5.2
standarditech

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 Lisää

$30 USD 1 päivässä
(67 arvostelua)
4.8
kkc1985612

"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 Lisää

$150 USD 3 päivässä
(12 arvostelua)
4.4
Programmer59

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 Lisää

$150 USD 5 päivässä
(6 arvostelua)
4.2
Mokshith30

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 Lisää

$61 USD 0 päivässä
(36 arvostelua)
4.3
akritisood94

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 Lisää

$100 USD 2 päivässä
(22 arvostelua)
4.3
xinglong717

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 päivässä
(5 arvostelua)
2.9
engelnady

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 Lisää

$30 USD 1 päivässä
(1 arvostelu)
2.3
HarleyJohnson

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 Lisää

$250 USD 3 päivässä
(1 arvostelu)
1.8
Karekin

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 Lisää

$166 USD 3 päivässä
(0 arvostelua)
0.0
KongHyongRan

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 Lisää

$30 USD 3 päivässä
(0 arvostelua)
0.0
Gaurav1309

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 Lisää

$60 USD 3 päivässä
(0 arvostelua)
0.0
evonsystems7

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 Lisää

$208 USD 7 päivässä
(0 arvostelua)
0.0
shezanpb

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 Lisää

$30 USD 3 päivässä
(0 arvostelua)
0.0