Fermé

Do some Excel Work

Hi Excel Expert,

We have got a list of business contact information data from some business directory.

I have 2 files:

File 1: It contains full business information, available fields are: Name Address1 Address2 Address3 Address4 Phone Fax Email Website Contact1 Contact2 Position1 Position2 Description Categories

Total rows: 9611 records

File 2: A list of email addresses only

Total row: 80K emails

What I want to achieve:

All these 80K emails (File 2) are generated based on email's domain & websites of File 1. So, there might be more than 1 email from each row of File 1. Example, there might be 10 emails under domain [url removed, login to view] from File2, and we need to add these 10 emails into File 1. Then there's also another 45 emails under domain [url removed, login to view] that I need to add into File 1.

In short, File 1 would be updated to have 80K rows from 9611 rows now, after added 80K emails from File 2. So, u got to add correctly those 80K emails based on domains available in File 1.

Secondly, this is much easier to do, we need to extract out the postcode from Address1 Address2 Address3 Address4 in File 1. Some postcode are on Address2, some postcode on Address3 or Address4. We need to take out the first 2 digit of the postcode and put up on new column.

Let me know your quote.

BR

Travis

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

Voir plus : what work can i do from home in india, how do i work as a freelance translator in venezuela, find me a typist who will come to my apartment to pic work do it then bring it back done, how to do data analysis in excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

Concernant l'employeur :
( 0 commentaires ) India

N° du projet : #13087855

34 freelance ont fait une offre moyenne de 452 RM pour ce travail

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

750 RM MYR en 1 jour
(128 Commentaires)
6.4
513 RM MYR en 3 jours
(59 Commentaires)
5.5
mariusalex86

Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable and hard working freelancer, focused on quality and accuracy. I will also do my best to finish the work within Plus

825 RM MYR en 8 jours
(30 Commentaires)
4.5
teeares

I can do this project. I would like to know whether the emails have to match not only with the website, but also with names in file 1. Please send the files, then I can send some sample work

116 RM MYR en 3 jours
(56 Commentaires)
5.1
513 RM MYR en 3 jours
(3 Commentaires)
2.1
rafeemd

I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.

291 RM MYR en 3 jours
(2 Commentaires)
2.2
SaadAmeen

Hello Dear Hiring Manager! I have read your posted job for data entry. I am well expert in this work and I am ready to do work with you. I am totally free and I can start work from right now. I am new on freelanc Plus

513 RM MYR en 3 jours
(1 Commentaire)
0.6
daliyavarghese

I am very comfortable working with Excel which will help me complete this project within the delivery date easily. I also have an eye for details and am meticulous which will ensure that the project is completed with m Plus

513 RM MYR en 5 jours
(0 Commentaires)
0.0
Shahillia

A proposal has not yet been provided

513 RM MYR en 3 jours
(0 Commentaires)
0.0
Mikehubber

Hi. You have stated the correlation between the 2 files is email and email domain so it sounds relatively straight forward. Pulling out a postcode from any of the 4 address fields should also be easy to program. I thin Plus

555 RM MYR en 1 jour
(0 Commentaires)
0.0
FelixMueller

Dear customer, I have a lot of working experience in similar projects. Since you are probably interested in a permanent solution, I recommend a VBA solution embedded in file 1 (unless file 1 gets replaced occasio Plus

500 RM MYR en 10 jours
(0 Commentaires)
0.0
rinitanair

Can get the work done in 2-3 days. Have experience using excel

166 RM MYR en 3 jours
(0 Commentaires)
0.0
222 RM MYR en 3 jours
(0 Commentaires)
0.0
gowrishaankar14

Hi, i like to work in excel and i am willing to work for you as soon as i saw your work description. I need a week time to complete this project. you can relay on me, my accuracy is good and i put more effort to maint Plus

288 RM MYR en 7 jours
(0 Commentaires)
0.0
anjani0804

A proposal has not yet been provided

513 RM MYR en 3 jours
(0 Commentaires)
0.0
burakbaysal

Dear employer I am eager to get this job because i need that and if you hire me, this will my first project and try to leave good impression on you. I will finish this job with great care within 1-3 days. I need Plus

344 RM MYR en 3 jours
(0 Commentaires)
0.0
amjadzaman40

Hello I have read your information and I will love to do your work. The main goal is customer satisfaction, I will give numbers of revisions for your work. I am a professional auto cad designer and data entry from la Plus

513 RM MYR en 3 jours
(0 Commentaires)
0.0
500 RM MYR en 3 jours
(0 Commentaires)
0.0
513 RM MYR en 3 jours
(0 Commentaires)
0.0
Debanandamishra

I have hands on with this kind of projects. I can provide you a better data and with the help of my skills i will get the correct email domain. Thanks Debananda

513 RM MYR en 3 jours
(0 Commentaires)
0.0