Excel Macro

Slutfört Publicerat 6 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

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

Datainmatning Databehandling Excel Visual Basic

Projekt-id: #15816269

About the project

17 offerter Distansprojekt Aktivt 6 år sedan

Tilldelades:

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 Mer

$30 USD inom 0 dagar
(32 omdömen)
4.9

17 frilansare har lagt bud på i genomsnitt $28 för det här jobbet

zExcel

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

$50 USD inom 0 dagar
(262 omdömen)
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 inom 0 dagar
(111 omdömen)
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 Mer

$16 USD inom 1 dag
(369 omdömen)
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 Mer

$25 USD inom 1 dag
(74 omdömen)
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 inom 1 dag
(38 omdömen)
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 Mer

$28 USD inom 1 dag
(27 omdömen)
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 inom 0 dagar
(42 omdömen)
4.5
nvbishr

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

$25 USD inom 1 dag
(7 omdömen)
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 Mer

$30 USD inom 4 dagar
(3 omdömen)
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 inom 1 dag
(0 omdömen)
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 Mer

$25 USD inom 1 dag
(0 omdömen)
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 Mer

$25 USD inom 1 dag
(0 omdömen)
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 Mer

$25 USD inom 1 dag
(0 omdömen)
0.0