Excel Macro

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

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@[login to view URL] and then a first name as BOB and last name as MARLEY it will find out that the email format is firstletteroffirstname(followedby)lastname@[login to view URL]

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

Data Entry Data Processing Excel Visual Basic

Project ID: #15816269

About the project

17 proposals Remote project Active 6 years ago

Awarded to:

jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

$30 USD in 0 days
(32 Reviews)
4.9

17 freelancers are bidding on average $28 for this job

zExcel

Will try to finish it right away Relevant Skills and Experience see my profile Proposed Milestones $50 USD - Milestone

$50 USD in 0 days
(262 Reviews)
7.7
periyannas

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

$30 USD in 0 days
(111 Reviews)
6.3
vano101

Hello. I have checked project description and it looks as easy project for me, there is about couple of hours of pure working time Relevant Skills and Experience I have strong VBA experience, I have already completed More

$16 USD in 1 day
(369 Reviews)
6.5
renesontiongson

Pleasure to help you. Excel automation is my masterpiece. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $25 USD - 100% milestone a More

$25 USD in 1 day
(74 Reviews)
5.5
abdolah2014

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

$30 USD in 1 day
(38 Reviews)
5.3
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks. Relevant Skills More

$28 USD in 1 day
(27 Reviews)
4.9
nurnga1218

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.

$30 USD in 0 days
(42 Reviews)
4.5
nvbishr

Please send me details. ......................................... Stay tuned, I'm still working on this proposal.

$25 USD in 1 day
(7 Reviews)
4.2
dhivya1enigma

Read the requirements. Bidding your proposed budget to win. Relevant Skills and Experience Have knowledge in Excel Macro. Proposed Milestones $15 USD - Completion of first three requirements $15 USD - Completion of 4 More

$30 USD in 4 days
(3 Reviews)
1.4
Woldofgraphic

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

$25 USD in 1 day
(0 Reviews)
0.0
shivashanker764

If i get this project, will deliver by on time with 100% quality. Relevant Skills and Experience I have 7 years of experience in Advanced excel and Macros Proposed Milestones $25 USD - I have 7 years of experience in More

$25 USD in 1 day
(0 Reviews)
0.0
jewelhe0225

I am interested in bidding your project. I have over 9 years' data entry working experience in Canada. Relevant Skills and Experience I am good skill at excel, word, outlook, access and PowerPoint Microsoft Office Pro More

$25 USD in 1 day
(0 Reviews)
0.0
begleyroberts

I can complete this quickly and am able to start immediately. I am certified for Microsoft excel to expert standard (by Microsoft). I am a data analyst and complete tasks such as this on a reg. basis Relevant Skills a More

$25 USD in 1 day
(0 Reviews)
0.0