Hi,
We have an Excel databases First Name, Last Name, email, company, address, mobile and cell numbers etc
We require:
Sheet 1
Remove any entry that has a number in Cell K - Only want to be left with entries that have no mobile number
Sheet 2
1. If Cell A, B and then either C, D, E, F or J are the same as entries within 4 up or 4 down then remove the entry if no number in K
[login to view URL] Cell A & B and either D, E,F or J are the same as entries within 4 up or 4 down then remove the line entry if cell C has @gmail, @yahoo, @ymail, @hotmail, @aol, @live, @msn, @outlook, @comcast, @att or @cox in the email address
[login to view URL] finally remove all entries that have a number in Cell K - I only want the ones with no mobile number left... But I need steps 1 & 2 done first to get rid of as many duplicate people as possible.
[login to view URL] that process then if in sheet 2 there is only 1 entry with the same name in column A & B can we move that entry back to sheet 1
I believe we need someone who is an expert in MS Excel and who knows VBA or Macros in MS Excel.
We require this work to be completed within 4 hours
Hi, Dear Prospective Client,
I’m Javed, my computer experience is 13 year's more. I’m expert on VBA, Macro, Compare multiple sheet, VLOOKUP, HLOOKUP, Data Cleaning and Advance Excel related various administration tasks. I've read your project description and understand this. I can cleanup your data as on your requirements with 100% accuracy.
Can you knock me in the chat list so that we can discuss more about this project? And start work.
I hope to hear from you soon!
Kindest regards,
Aquib Javed
$30 AUD en 1 jour
4,8 (19 commentaires)
3,8
3,8
6 freelances proposent en moyenne $24 AUD pour ce travail
hi,
I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel.
I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me.
Thanks.
Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, ready to start right now, message me and let is discuss about the project and time. Ready to start right away
4h
Hello
I see your project description and am really excited about this Project. Send me a message on the Freelancer Chat list for discussion. I hope I will provide you of my best job. I want to start the job immediately.
Delivery time: As you want.
Thanks
Mahamud
I have international experience in IT industry with 4 years of experience in India and 1 year of experience in Ireland. I have completed masters in Data analytics and masters of science in computer application. I can assure you that I can compelete this work quickly.