Looking for an Excel expert to create a quick macro that will do the following:
1) it will check the column "first name" for empty cells and will delete the entire row
2) same as 1) but for the column "last name"
3) same as 1) and 2) if it encounters only one letter for example a first name cell that just says A or a last name cell that says J
4) it will ask me in which columns are located first and last name and also emails and then using the email column together with first and last name will create an additional column with email formats. For example, if it finds and email as bmarley@[url removed, login to view] and then a first name as BOB and last name as MARLEY it will find out that the email format is firstletteroffirstname(followedby)lastname@[url removed, login to view]
5) once all of the steps above are completed, it will use the company name column together with the email format column and remove all duplicates
Looking for someone that can start right away and complete this immediately
MAX BID: $30
19 freelancers are bidding on average $27 for this job
HI I am an excel-vba Expert and I can finish you project in less than 2 hour start the chat to finish it up Relevant Skills and Experience vba Excel expert Proposed Milestones $30 USD - 1
Hi, Can you please send me your excel file. I will make a concept and show you how I work. I think it will not more than 2 hours. Stay tuned, I'm still working on this proposal.
Sure. Let me do it right away. But need clarity on the 4th point. Thank you. Relevant Skills and Experience excel vba Proposed Milestones $30 USD - Task
I have 5+ yrs exp in excel macro and web scraping using the vba, i will do this for you. Relevant Skills and Experience yes Proposed Milestones $25 USD - For completing the project
I Do this job very fastly and good Relevant Skills and Experience Data Processing, Excel Proposed Milestones $25 USD - I can provide you better output