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:
Org Short Name
<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)
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.
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.
20 freelancer đang chào giá trung bình $144 cho công việc này
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
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. :)