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.
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.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
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
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.
with thanks and regards
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. :)
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
Thanks
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 Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
"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, request and etc in python.
-save data scraped into xlsx, csv, mysql and etc using xlsxwriter and csv.
-create bots and website replica.
I have just completed the same project.
Please feel free to contact me if you have any further questions. I look forward to hearing back from you.
Thank you!"
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 information related to your project Can we discuss the project ?
I am waiting for your response
Thank you
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
? Google Spreadsheet Entry
? Property Research
? Data Extraction
? Manual typing Work
? Product listing
? Image to Word or Excel
? PDF to Word or Word to PDF
? PDF to Excel or Excel to PDF
? Scanned Pages to Excel/Word
? Any Type of Data Entry Projects.
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 Excel, VBA and Data processing as I've been developing many projects for 15+ years. I'm just new to freelancing. It's my pleasure to get your choice and to work with you. I'm sure you will be fully satisfied. Waiting for your appreciated reply.
Thank you
Regards
Mohammed
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 cheap rate because I have to build up my profile. Thank you.
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 you the free sample as to ensure my quality.
Thanks & Regards,
Gaurav Wadhwa