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

Completed Posted Jan 24, 2015 Paid on delivery
Completed Paid on delivery

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.

Data Entry Data Processing Excel

Project ID: #7024498

About the project

24 proposals Remote project Active Jan 24, 2015

Awarded to:

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 More

$80 SGD in 3 days
(11 Reviews)
4.4

24 freelancers are bidding on average $113 for this job

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

$100 SGD in 1 day
(190 Reviews)
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 More

$175 SGD in 3 days
(145 Reviews)
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 in 3 days
(99 Reviews)
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

$70 SGD in 1 day
(100 Reviews)
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 More

$150 SGD in 3 days
(20 Reviews)
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 More

$100 SGD in 3 days
(55 Reviews)
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 More

$111 SGD in 3 days
(79 Reviews)
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 in 3 days
(34 Reviews)
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 More

$83 SGD in 1 day
(50 Reviews)
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 in 2 days
(12 Reviews)
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 More

$80 SGD in 3 days
(6 Reviews)
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 More

$216 SGD in 3 days
(1 Review)
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 in 3 days
(1 Review)
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 More

$83 SGD in 3 days
(2 Reviews)
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 More

$194 SGD in 3 days
(0 Reviews)
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 in 2 days
(0 Reviews)
0.0
sherif2010

A proposal has not yet been provided

$111 SGD in 2 days
(0 Reviews)
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 More

$89 SGD in 3 days
(0 Reviews)
0.0
biexcel

at your disposal to discuss the details

$133 SGD in 2 days
(0 Reviews)
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 More

$155 SGD in 3 days
(0 Reviews)
0.0