Do some Excel Work

Κλειστό Αναρτήθηκε Πριν 7 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

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

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel

Ταυτότητα Εργασίας: #13087855

Σχετικά με την εργασία

34 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 7 χρόνια

34 freelancers κάνουν προσφορές κατά μέσο όρο RM452 για αυτή τη δουλειά

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.

RM750 MYR σε 1 μέρα
(128 Αξιολογήσεις)
6.4
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 Περισσότερα

RM825 MYR σε 8 μέρες
(30 Αξιολογήσεις)
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

RM116 MYR σε 3 μέρες
(56 Αξιολογήσεις)
5.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.

RM291 MYR σε 3 μέρες
(2 Αξιολογήσεις)
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 Περισσότερα

RM513 MYR σε 3 μέρες
(1 Κριτική)
0.6
agsGreeksolution

Hey, i am interested in your project. Please send me a message so that we can discuss more details. I have 4 years working experience in this field.

RM116 MYR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
mostafajamanparv

I am new in this job site,I do it at a low price

RM513 MYR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
HardikDesaii

A proposal has not yet been provided

RM333 MYR σε 10 μέρες
(0 Αξιολογήσεις)
0.0
tharindu10

A proposal has not yet been provided

RM513 MYR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
amossiame

A proposal has not yet been provided

RM277 MYR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
raxfaajaune

A proposal has not yet been provided

RM460 MYR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
princeasitha

Dear sir/madam,I'm expert to data entry projects,please give me that project,and i would like to do that correctly and neatly

RM115 MYR σε 5 μέρες
(0 Αξιολογήσεις)
0.0
hamwambui99

I am delighted to submit this proposal for the Provision of Data Entry services. In this regard, I submit our proposal for the provision of the above services to you and accept the challenge to deliver on our commitmen Περισσότερα

RM888 MYR σε 15 μέρες
(0 Αξιολογήσεις)
0.0
MrAayushAg

A proposal has not yet been provided

RM600 MYR σε 2 μέρες
(0 Αξιολογήσεις)
0.0
Pallani22

Being a computer science engineer, I think I am more capable to get the project and I have work experience of 2 years also.

RM513 MYR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
rinitanair

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

RM166 MYR σε 3 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

RM513 MYR σε 3 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

RM288 MYR σε 7 μέρες
(0 Αξιολογήσεις)
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

RM513 MYR σε 3 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

RM500 MYR σε 10 μέρες
(0 Αξιολογήσεις)
0.0