Terminé

Excel Macro

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

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic

Voir plus : Create a Macro in Excel , create stopwatch macro excel, excel macro import csv create pivot table, need excel expert create macro, macro outlook 2010 export emails excel, create gui macro excel, looking excel expert create multiple macros, create custom macro button excel, using expert advisors, exchange 2007 send emails using smtp, macro export calendar file pst using vba outlook, create installer macro excel, send emails using vbnet visual studio 2005, excel vba create installer macro, reading emails using php pop, code html emails using psd, constant contact emails using css, create internet macro excel, create print macro excel, excel create html macro, create html emails using adobe cs3, send bulk emails using yahoo, releasing emails using outlook macro, create emails using access, creating html emails using fireworks

Concernant l'employeur :
( 448 commentaires ) Richmond Hill, Canada

N° du projet : #15816269

Décerné à :

jasalaz100

Immediate [url removed, login to view], 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 Plus

30 $ USD en 0 jours
(13 Commentaires)
4.0

19 freelance font une offre moyenne de $27 pour ce travail

zExcel

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

50 $ USD en 0 jours
(259 Commentaires)
7.7
SBITServices

Hello , I have done similar project to previous client. I have 5 years experience and completed 500 projects till now. I agree that can complete task with high quality and [url removed, login to view] our reviews to confirm our Plus

30 $ USD en 1 jour
(299 Commentaires)
7.2
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 Plus

16 $ USD en 1 jour
(315 Commentaires)
6.3
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 Plus

25 $ USD en 1 jour
(67 Commentaires)
5.3
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 en 1 jour
(38 Commentaires)
5.3
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 en 0 jours
(34 Commentaires)
4.4
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 en 0 jours
(14 Commentaires)
3.9
nvbishr

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

25 $ USD en 1 jour
(4 Commentaires)
3.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 Plus

28 $ USD en 1 jour
(7 Commentaires)
2.9
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 Plus

30 $ USD en 4 jours
(3 Commentaires)
1.5
25 $ USD en 1 jour
(1 Commentaire)
0.8
20 $ USD en 1 jour
(0 Commentaires)
0.0
Prakashscrapper

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

25 $ USD en 1 jour
(0 Commentaires)
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 Plus

25 $ USD en 1 jour
(0 Commentaires)
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 Plus

25 $ USD en 1 jour
(0 Commentaires)
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 Plus

25 $ USD en 1 jour
(0 Commentaires)
0.0
25 $ USD en 1 jour
(0 Commentaires)
0.0
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 en 1 jour
(0 Commentaires)
0.0