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.
34 freelance font une offre moyenne de RM452 pour ce travail
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.
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
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
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.
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
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
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
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
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
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
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
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