Käynnissä

Excel tidy up sheets - names address files

I have an excel spreadsheet with 8 sheets in it. On each sheet are company names, addresses, phone numbers, and some emails. Each sheet represents 1 country and in total there are about 30,000 records.

What I'd like done is all the sheets consolidated into one. Then I would like all of the duplicate email addresses removed (but not with the corresponding records).

In each sheet, an extra column with the country will need added so when theyre consolidated there's a country column. Right now all the sheets dont appear in the same format order - some are name, address emai, and others are email, name, telephone and so on.

If you dont know how to write and run macros, this isn't for you. I dont know how to do it but I know there's a macro you can run to eliminate all duplicate emails for example. So this job should only take 3 hours maximum for someone with genuine expert knowledge in excel.

So please dont apply unless you have this knowledge.

Thanks

Taidot: Excel

Näytä lisää: tidy addresses excel, excel tidy names, write names, what job for an excel expert, names and numbers, macros expert, job for excel expert, how to expert in excel, how can write email address, how can i expert in excel, expert with excel, expert excel job, excel macro how to, excel expert up, excel 0 to expert, address write, name someone tidy, tidy names excel, tidy email addresses excel, excel address tidy, name address sheet, excel macro target custom name adress, excel look tidy, macro excel sheets consolidated, company names phone numbers

About the Employer:
( 79 reviews ) London, United Kingdom

Projektin tunnus: #468467

Myönnetty käyttäjälle:

Kzafar

Please check PM for More details

30 $ USD 1 päivässä
(1 arvostelu)
1.6

18 freelanceria on tarjonnut keskimäärin 48 $ tähän työhön

gangabass

I can do this job for you. See PM for details.

30 $ USD 0 päivässä
(35 arvostelua)
4.7
SouthIndian

Letz start. Thanks.

30 $ USD 0 päivässä
(38 arvostelua)
4.4
ajaszin

Please have a glance at PMB...

30 $ USD 1 päivässä
(8 arvostelua)
3.6
neelu7779

Please check PMB

40 $ USD 5 päivässä
(2 arvostelua)
2.0
sumeet00

Hi, Check PM. Thanks, Sumeet.

50 $ USD 2 päivässä
(1 arvostelu)
1.0
rief

Hi, 8 years experience working with Excel, that's enough for me to handle this. Please see detail on PMB how I plan to manipulate your data

35 $ USD 1 päivässä
(1 arvostelu)
1.0
ashanidarshika

Hi, I am interested in this project. Kindly help me by providing this project.I hope to do my best for that project.

55 $ USD 5 päivässä
(0 arvostelua)
0.0
habibster

I can complete this job within two hours. I've worked with Excel database for about three years now at my current job.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
soniamakan

I can do excel work as I have a good experience in this field within time and upto your expectation. thanks/ Sonia

100 $ USD 7 päivässä
(0 arvostelua)
0.0
freedom71

Hello, I would like to work on this project. Pls check pmb. Thanx.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
dicadio

Please check your pmb,

35 $ USD 0 päivässä
(0 arvostelua)
0.0
farhan7147

Pleasure to do this job for u I Can do Easily Thanks Please see pm

30 $ USD 0 päivässä
(0 arvostelua)
0.0
kerrykon

I have knowledge in running macros for situations like this for the military. I can deliever what you need.

100 $ USD 2 päivässä
(0 arvostelua)
0.0
Benardatelo

Hallo. Give this project. I understand this kind of project so deeply as i have done such projects in the past. I am placing as a bid just to compensate for the time that will be spent. I also want to tell you that i Lisää

150 $ USD 5 päivässä
(0 arvostelua)
0.0
GeorgeGA

Hello, I can to do this task for you in 2 ours, ready start ASAP. Thanks for your time.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
keenenterprises

"WE CAN & WE WILL" by this motto we work. We have an experience team who work on many different project. I think if we join our hand we will never let your acceptation down and do the work with honest and on given time Lisää

30 $ USD 5 päivässä
(0 arvostelua)
0.0
Palashepz

I have lot of experience in excle. You can check me to seclect for this work. I am ready to do this work. Please view my profile in my PM.

30 $ USD 0 päivässä
(0 arvostelua)
0.0