Combine and de-duplicate various date versions of excel spreadsheets into 2 master spreadsheet

已完成 已发布的 Jan 24, 2015 货到付款
已完成 货到付款

Hi I am a researcher and I need someone to help me combine monthly versions of spreadsheet into an updated master spreadsheet. I have 2 sets of spreadsheets that I need this to be done.

First Set of Excel Spreadsheet: EventsEye

Number of Spreadsheet versions to combine: 7 versions

EventEye_13 Jun 2014

EventEye_17 Jun 2014

EventEye_1 Oct 2014

EventEye_31 Oct 2014

EventEye_1 Dec 2014

EventEye_15 Dec 2014

EventEye_31 Dec 2014

I want to combine all the versions into one master spreadsheet. The master copy must have all the most updated and added records, and also all the past records. As these different versions are extracted over different months from an online directory, some information may be taken down whilst newer information are added (as seen in the latest version). In summary I want all the records to be in here (old + new) in one master spreadsheet. I need them the master spreadsheet to be deduplicated and only contain unique records.

Second Set of Excel Spreadsheet: Jetro

Number of Spreadsheet versions to combine: 7 versions

Jetro_13 Jun 2014

Jetro_17 Jun 2014

Jetro_6 Aug 2014

Jetro_1 Oct 2014

Jetro_31 Oct 2014

Jetro_1 Dec 2014

Jetro_31 Dec 2014

Same instructions as per the first set of spreadsheet.

In summary, I want 2 complete set of master database with everything in and updated. All records must be deduplicated accordingly.

Selected freelancer needs to complete this activity within 3 days after being awarded the bid. Interested bidders please quote project reference - SLPJ_EEJT_2014. Please find attached 2 sample screenshot of the excel spreadsheet for reference.

数据输入 数据处理 Excel

项目ID: #7024498

关于项目

24个方案 远程项目 活跃的Jan 24, 2015

授予:

Halgren

Greetings I have experience in the data processing field and I can complete this task within 3 days as requested. However first I would need some clarification on two details: 1) So eventually you need 2 master spr 更多

$80 SGD 在3天内
(11条评论)
4.4

有24名威客正在参与此工作的竞标,均价$113/小时

bayzidkhan

Sir, I am willing to do your project and ready to start work. I will provide you a good result . My aim is to satisfy my client by my work . Please response . Thanks

$100SGD 在1天里
(190条评论)
7.5
hdlong66

Hello, I am highly interested in your project and able to deliver quality work. Kindly refer to my similar projects at https://www.freelancer.com/projects/Data-Entry-Excel/Merge-edit-two-email-lists.html https://www 更多

$175 SGD 在3天内
(145条评论)
6.9
raghav1101

Hi, I would love to work on this project. I have experience in similar projects and i am sure i can deliver within 24 hours. Kindly get in touch. Regards, Raghav Bansal

$85 SGD 在3天内
(99条评论)
6.6
gokulanand

Hello, I can get this task done using a Excel macro on a button click. I will make sure to get this done in the next 12 to 24 hours. Let me know if you are interested. Thanks

$70SGD 在1天里
(100条评论)
6.0
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee 更多

$150 SGD 在3天内
(20条评论)
5.8
mdreju

To whom it may concern: Your project sounds feasible enough and all steps can be performed very easily, so it will be simple to integrate with any documents you may be using at this point. I have many years of experien 更多

$100 SGD 在3天内
(55条评论)
5.8
sangwanpankajs

SLPJ_EEJT_2014 Hello sir, I am good at excel, data processing and understood you project and would like to work on it Give me a chance to prove my skills , I will ensure you quality work and timely submissio 更多

$111 SGD 在3天内
(79条评论)
5.3
quickprogexpert

Hello, Greetings from Shweta. I have experience in handling excel files using perl. I can get this done in 2 days. thanks, Shweta

$100 SGD 在3天内
(34条评论)
5.2
prabakarm23

SLPJ_EEJT_2014 Greetings for the Day!!! I have 6 years of experience in .NET, Excel, word ,VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Tex 更多

$83SGD 在1天里
(50条评论)
4.7
sreejithakaz

I have over 9 years of experience in Excel, and VBA . I have developed several Tools, Automation, Dashboard, Database CRM and Tools using VBA. I have done similar project using VBA.

$98 SGD 在2天内
(12条评论)
3.9
kapekape

HI I AM AN EXPERT IN EXCEL, VB AND MACROS Please send me a message so that we can have a dialogue I am available now you can access my cell phone number from the freelancer site Project reference - SLPJ_EEJT_2014 更多

$80 SGD 在3天内
(6条评论)
3.4
byron743

'' SLPJ_EEJT_2014 ''hi, i am a professional data analysis with the skills tools ad experienced to deliver the quality results you seek and desire after. i am ready to discuss additional details and get started immed 更多

$216 SGD 在3天内
(1条评论)
1.3
abadh100

project reference - SLPJ_EEJT_2014 Dear Sir/Madam, I can work for your precious data and combine it to make master spreadsheet in efficient manner. Thanks Abadhesh

$155 SGD 在3天内
(1条评论)
0.7
satnamsidhu

"- SLPJ_EEJT_2014" I will move all your data from Events eye data and jetro in two different files. But i have a question do you need data from recent file to be replaced with previous file data OR both of them. Than 更多

$83 SGD 在3天内
(2条评论)
0.8
Mostert5

I am a hard working loyal person who enjoys taking on new challenges. I can easily work with others in a group and can also handle large tasks on my own. I am a go getter and like to set high goals for myself. I can 更多

$194 SGD 在3天内
(0条评论)
0.0
jotey00

Hi, I have 15 years experience in Microsoft's Excel, so I can provide you a quality and affordable service. I am Microsoft's Excel Power Users and I can use most of the excel functions and features.

$100 SGD 在2天内
(0条评论)
0.0
sherif2010

A proposal has not yet been provided

$111 SGD 在2天内
(0条评论)
0.0
agullotti

Thank you for considering my bid. I can combine the spreadsheets according to your instructions and remove any duplicate entries. If chosen I can submit a sample file within 24 hours for you to confirm all instructions 更多

$89 SGD 在3天内
(0条评论)
0.0
biexcel

at your disposal to discuss the details

$133 SGD 在2天内
(0条评论)
0.0
lo2ma

I can accomplish the job via a data integration tool called Informatica Powercenter and the job can be accomplished in no time (2 days) which accomplish the job perfectly. I'm an expert in Data Integration with 3 ye 更多

$155 SGD 在3天内
(0条评论)
0.0