Suoritettu

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

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: 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 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, surf internet work excel

Tietoa työnantajasta:
( 8 arvostelua ) Petaling Jaya, Malaysia

Projektin tunnus: #13087530

Myönnetty käyttäjälle:

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 1 päivässä
(174 Arvostelua)
6.4

61 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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, Lisää

RM390 MYR 6 päivässä
(94 arvostelua)
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 Lisää

RM800 MYR 1 päivässä
(110 arvostelua)
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 Lisää

RM200 MYR 1 päivässä
(97 arvostelua)
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 5 päivässä
(42 arvostelua)
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 Lisää

RM500 MYR 5 päivässä
(36 arvostelua)
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 Lisää

RM513 MYR 1 päivässä
(42 arvostelua)
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 Lisää

RM825 MYR 8 päivässä
(30 arvostelua)
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 Lisää

RM500 MYR 3 päivässä
(7 arvostelua)
4.5
RM116 MYR 1 päivässä
(12 arvostelua)
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 3 päivässä
(2 arvostelua)
2.2
suryasalur

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

RM500 MYR 13 päivässä
(5 arvostelua)
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 Lisää

RM513 MYR 3 päivässä
(1 arvostelu)
0.4
RM666 MYR 3 päivässä
(0 arvostelua)
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 Lisää

RM500 MYR 4 päivässä
(0 arvostelua)
0.0
RM888 MYR 10 päivässä
(0 arvostelua)
0.0
tabishmalick

A proposal has not yet been provided

RM555 MYR 6 päivässä
(0 arvostelua)
0.0
RM513 MYR 3 päivässä
(0 arvostelua)
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 3 päivässä
(1 arvostelu)
0.0
Blazny

A proposal has not yet been provided

RM555 MYR 5 päivässä
(0 arvostelua)
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 Lisää

RM513 MYR 3 päivässä
(0 arvostelua)
0.0