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.
项目ID: #7024498
关于项目
有24名威客正在参与此工作的竞标,均价$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
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
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.
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 更多
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.