I have a few excel spreadsheets where multiple times the first name is in the last name field and vice versa. I am looking for someone to write code that goes through these files in excel macro code that reverses the first name and last name field values if they are in the wrong place.
The first file has 450,000 records. The first name file has 35,000 records.
The algorithm should use a public domain first names database that we will provide and scan the last name field to see if there is a first name value in that field. If there is a first name value in the last name field, it should then check the first name field to see if the first name field has a first name value, if not, it should swap the values.
There needs to be 3 tabs. The first tab is the original file. The second tab is a copy of each original record where the first name and last name where swapped.
A second scan of the first name fields in the first tab should be done. In the second scan, after the first scan that rearranges first and last names, it should scan the first names field again to see if there are values in the first name field that are still not in the first name database. Any record with a value in the first name field that is not in the first name database should be cut and put into the 3rd tab.
Please send me samples of past work, etc. How long you think it will take. How many hours of work and testing.
Please share the requirement .Expect periodic updates .Please trust and give a chance will not disappoint [login to view URL] message me for the requirements.
Bu iş için 25 freelancer ortalamada $110 teklif veriyor
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not Daha Fazla
Hi, I'm very much interested in this project. I have good experience in scan excel files for first names in last name field and switch them. I ensure you, sir, I will provide you with better quality work than others. Daha Fazla
Hello . How are you. I can access and control excel programically. I suggest you programming based way using java or python . I can help you .Thank you.
Hi sir/mam Hopefully, you will be enjoying a good day. My name is Imran. I am a certified excel professional. I recently completed a task like it. please check the portfolio for samples and satisfaction. I read the des Daha Fazla
Hi there I can help you create an EXCEL with all the details. I have good experience in this. It will be my first freelance work on this site. Please feel free to email me Thanks.
Sir,That's a very great opportunity for me to work with you.I am interested in your [login to view URL]'s a very simple project for [login to view URL],Give that opportunity to [login to view URL] to meet you. Thanks in Advance.
Hello sir my name is nagendra your project I want to do this work, so I will do your work according to your order.
Hi…. I am an engineer I understand your order (I am Expert Excel) Please send me a message now so that we can discuss more. The price is negotiable.
I'm an organized and detailed person and have over 12 years of experience working with Office packages. I'm fast and efficient in data entry, error-free, so I would do a good job doing this.