Combine and de-duplicate various date versions of excel spreadsheets into 2 master spreadsheet
$30-250 SGD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #7024498
Σχετικά με την εργασία
Ανατέθηκε στον:
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 Περισσότερα
24 freelancers κάνουν προσφορές κατά μέσο όρο $113 για αυτή τη δουλειά
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
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 Περισσότερα
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
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
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
Hello, Greetings from Shweta. I have experience in handling excel files using perl. I can get this done in 2 days. thanks, Shweta
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 Περισσότερα
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.
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 Περισσότερα
'' 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 Περισσότερα
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
"- 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 Περισσότερα
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 Περισσότερα
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.
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 Περισσότερα
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 Περισσότερα