Færdiggjort

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

Evner: Dataindførsel, Databehandling, Excel

Se mere: 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, data processing, excel, how to do data analysis in excel, macros work excel internet, macro dont work excel 2000, freelance work excel vba, track work 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

Om arbejdsgiveren:
( 8 bedømmelser ) Petaling Jaya, Malaysia

Projekt ID: #13087530

Tildelt til:

best4best

Hi, Please share both the Excel files, I am an Excel expert and can arrange the email data from file2 to file1 as per your instructions with great accuracy. Regards Rav

RM180 MYR på 1 dag
(174 bedømmelser)
6.4

61 freelancere byder i gennemsnit RM441 på dette job

mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Flere

RM390 MYR in 6 dage
(94 bedømmelser)
6.5
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Flere

RM800 MYR på 1 dag
(110 bedømmelser)
6.1
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Flere

RM200 MYR på 1 dag
(97 bedømmelser)
6.1
ansarrali

Hi, hope you doing great. I can get all the emails required. I assure you the accuracy in my work. Kindly, provide me this opportunity. Thank you. Kind Regards, Ali

RM850 MYR in 5 dage
(42 bedømmelser)
5.5
abdussamad

Self-motivated professional, certified data entry specialist, a proficient web researcher and transcriber, blogger, web designer, Wordpress and various social sites marketer, knowledgeable in SEO, and technical / help Flere

RM500 MYR in 5 dage
(36 bedømmelser)
5.6
andriphone0

Hi, Please refer to your Message, So we can create sample work right away before awarding the project. I have read description carefully and I understand your project concern and ready to start immediately. I w Flere

RM513 MYR på 1 dag
(42 bedømmelser)
5.2
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 Flere

RM825 MYR in 8 dage
(30 bedømmelser)
4.5
shanthimv

Hi, I would like to work in this project. I have got your requirement clearly and is well explained in the description. I assure you that I will update file 1 with all the emails from file 2 to the appropriate domai Flere

RM500 MYR in 3 dage
(7 bedømmelser)
4.5
RM116 MYR på 1 dag
(12 bedømmelser)
3.9
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.

RM194 MYR in 3 dage
(2 bedømmelser)
2.2
suryasalur

I had good experience with this type of job can update 80k rows and can also update post codes

RM500 MYR in 13 dage
(5 bedømmelser)
1.6
htiwary

I had just completed australian estate agency work where i had listed around 10K agents and their full details and for that i had visited almost 200 websites and that's only in 36 hours. I can assure you of timely a Flere

RM513 MYR in 3 dage
(1 bedømmelse)
0.4
RM666 MYR in 3 dage
(0 bedømmelser)
0.0
ZuraidaZul

Dear Sir, Your job caught my attention straight away and I have read your job description. I believe that I am a suitable candidate for the job. I'm familiar with excel spreadsheet, data entry & data sourcing. I'm Flere

RM500 MYR in 4 dage
(0 bedømmelser)
0.0
RM888 MYR in 10 dage
(0 bedømmelser)
0.0
tabishmalick

A proposal has not yet been provided

RM555 MYR in 6 dage
(0 bedømmelser)
0.0
RM513 MYR in 3 dage
(0 bedømmelser)
0.0
Christie17

Hi, I've gone through the project details, and understand what you are trying to achieve. I'd like to speak with you to confirm project. Thanks

RM222 MYR in 3 dage
(1 bedømmelse)
0.0
Blazny

A proposal has not yet been provided

RM555 MYR in 5 dage
(0 bedømmelser)
0.0
toni9007

Hi Sir, So if I understand correctly you want to add the correct e-mail for each of your partners in File 1? But some of them are missing there and they are actually in file 2? I think that I can just use a combinat Flere

RM513 MYR in 3 dage
(0 bedømmelser)
0.0