Tamamlanmış

scan excel files for first names in last name field and switch them

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.

Beceriler: Excel Macros, Excel VBA, Excel

Daha fazlasını gör: excel formula to separate first and last name with space, reverse last name first name in excel with comma, how to switch first and last name in excel with comma, how to separate first name middle name and last name in excel using formula, how do i reverse the last name first in excel?, how to flip the first and last name in cells in excel and remove comma, excel formula last name comma first name, how to flip the first and last name in cells in excel and add comma, differences excel files, large excel files, merge excel files, compare excel files, combine excel files, fetch data excel files, j2ee reading excel files, locking excel files, lock excel files, code compare excel files find similar items, create excel files mysql, code compare excel files aspnet

İşveren Hakkında:
( 19 değerlendirme ) dania beach, United States

Proje NO: #21598356

Seçilen:

desiresky

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.

%selectedBids___i_period_sub_7% gün içinde 40%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
0.8

Bu iş için 25 freelancer ortalamada $110 teklif veriyor

P0L

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(308 Değerlendirme)
7.3
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, MS Word, Google Sheet, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/ Daha Fazla

$140 USD in 2 gün içinde
(47 Değerlendirme)
5.7
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your pr Daha Fazla

$50 USD in 2 gün içinde
(62 Değerlendirme)
5.7
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. wi Daha Fazla

$194 USD in 4 gün içinde
(43 Değerlendirme)
5.5
StormLion227

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)
4.5
susanna2018

⭐⭐⭐ Hi, Dear client. ⭐⭐⭐ I'm very interested your project. I read your description carefully. I'm very talented Excel & Python expert with full time. If you assign to me this project, you can get a cool result. If I Daha Fazla

$140 USD in 7 gün içinde
(7 Değerlendirme)
3.9
belalihabibullah

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(24 Değerlendirme)
4.1
sunshine7677

Dear Client, I can do this Project and ready to start the work right away. I have 5+ Years of Experience in EXCEL (VBA and MACROS), Web Scrapping (Python, Octoparse, Parsehub,Selenium and Beautifulsoup), Data Entry, P Daha Fazla

$150 USD in 3 gün içinde
(19 Değerlendirme)
4.1
kayemhussain

Dear hiring manager,, Fully understand your requirements & i am ready to start your work now & deliver to you within right time.I am highly experienced .Please sir give me a chance .I will start your work now. Than Daha Fazla

$140 USD in 7 gün içinde
(20 Değerlendirme)
3.6
kipdev13

Hello! Nice to meet you. I have read your proposal carefully and very interesting in your work. I have 10+ years experiences about excel data processing by C++/C#/Qt programming. Sure you will get good result. I will Daha Fazla

$100 USD in 2 gün içinde
(4 Değerlendirme)
2.3
TMLPakistan

Hello This is shajiah My working methodology is quite simple & effective that is; -100% job satisfaction. -On Time Delivery of each & every Project. -Unlimited Revisions. -Maintain Long Term Relationship with our each Daha Fazla

$150 USD in 3 gün içinde
(2 Değerlendirme)
1.0
yongan20151117

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
1.0
manibhai833

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.6
Lminox

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.

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0
Snail0917

Please give me the opportunity to work with you. Data Entry(Excel & VBA) is a simple project for me. Hello sir! Nice to meet you. I am very interested in your project. I am a data entry expert. I have rich experi Daha Fazla

$100 USD in 3 gün içinde
(0 Değerlendirme)
0.0
shoaibshams79321

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.

$40 USD in 2 gün içinde
(0 Değerlendirme)
0.0
diegofpr

Hello, I am a developer with 20 years of experience. I've worked with excel vba and macros (mainly for internal purposes, to properly adapt data for reports, etc.) I believe what you are trying to achieve can be also Daha Fazla

$50 USD in 3 gün içinde
(1 Yorum)
0.0
Deta6268

Hello sir my name is nagendra your project I want to do this work, so I will do your work according to your order.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Mohammedelouh

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.

$140 USD in 2 gün içinde
(1 Yorum)
0.0
tjelena6

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.

$223 USD in 5 gün içinde
(0 Değerlendirme)
0.0