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.