Find Jobs
Hire Freelancers

match 3 different excel workbooks and compare different values

€250-750 EUR

Closed
Posted almost 5 years ago

€250-750 EUR

Paid on delivery
Dear gentlemen, My name is Christos and i have a job for you. At first I want to match data from 3 different excel workbooks (with multiple criteria). Afterwards i want to compare data in different columns and extract excel reports. The problem is that the work books are quite big (10.000+ rows and 20+ columns each ) so a simple xlsm wont work (excel crashes). It sounds simple but its not that easy. I am waiting for your suggestions/offers. Thank you in advance
Project ID: 19320283

About the project

71 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
71 freelancers are bidding on average €381 EUR for this job
User Avatar
Hi Sir/Madam, It is being my pleasure to introduce you to me. I am an expert in advance excel. I have excellent knowledge of advance excel and VBA macro coding. I know many things in excel like Formulas (Countif, Sumif, Index match, Vlookup and offset etc.), Pivot, validation, macro, Pivot chats etc. I will match 3 different excel workbooks and compare different values. Please review my profile. My profile is suitable for this project. I will complete this project on time. Please give me a chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786
€500 EUR in 0 day
5.0 (621 reviews)
8.6
8.6
User Avatar
Hi, my name is Selim. I am from Solihull, UK. I read your `match 3 different excel workbooks and compare different values` project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
€500 EUR in 10 days
4.9 (370 reviews)
8.4
8.4
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€250 EUR in 4 days
4.9 (633 reviews)
8.6
8.6
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
€300 EUR in 3 days
5.0 (505 reviews)
8.0
8.0
User Avatar
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I can match and compare those 3 sheets ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
€388 EUR in 5 days
4.9 (222 reviews)
8.1
8.1
User Avatar
Hello Christos, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
€350 EUR in 3 days
5.0 (339 reviews)
7.5
7.5
User Avatar
Hi Christos, I propose to use Excel macros to meet your requirement. To avoid crashing, there are a few options like exporting data to a temporary text file or keeping data in memory for comparing which I have implemented earlier successfully. Let me know and we can discuss. Regards, Arul
€300 EUR in 3 days
5.0 (257 reviews)
7.4
7.4
User Avatar
Hello Christos, Hope you are doing well. I have reviewed your requirement and would like to offer you my services. I am highly proficient in Excel and other Ms tools. I can do this job for you. We have few excel add-ons and I can handle big Excel files easily. Please send me a message and share all the files you have and I will review them properly and will share an analysis and process on how I will complete the job. Looking forward to your reply. Regards Nick
€250 EUR in 2 days
4.7 (477 reviews)
8.0
8.0
User Avatar
***Hello Christos *** You are a good client who has given clear description and so much interested with your project. I have a small data entry experts group and have multiple machines so that I can manage your work easily. ***I ensure you 100% accuracy and fast delivery.** Christos , I have suggestion to manage your work easily and fast. Can we make a discussion please??? Eagerly waiting for you. Thank You, Amran
€500 EUR in 7 days
5.0 (145 reviews)
7.0
7.0
User Avatar
to match data from 3 different excel workbooks (with multiple criteria). (10.000+ rows and 20+ columns each )
€400 EUR in 10 days
5.0 (156 reviews)
6.9
6.9
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Let me check the data files and review the requirement, so that I can give you my opinion. Thank you, Regards.
€333 EUR in 3 days
5.0 (189 reviews)
7.0
7.0
User Avatar
Dear hiring manager, I am interested in your project. Yes, I am available right now to do your job. I think I am the suitable person for this position. Please don’t be fell hesitate to invite me. I am expert in Data Entry, Data Processing, Excel, Software Architecture, Visual Basic etc. Please check my profile and let me know if you are interested. Thanks
€250 EUR in 10 days
5.0 (103 reviews)
6.5
6.5
User Avatar
Hi, As per requirements I will develop VBA macro for you which will match three sheets and compare data as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I am ready to work on this project now. Please give me this opportunity to work on your project. Thanks and regards, Mohan
€299 EUR in 5 days
5.0 (104 reviews)
6.5
6.5
User Avatar
Hi there, it's an interesting project. As you noticed, the vba code into Excel is not able to handle huge amount of data. I suggest a console/winform application with c# using multithreads to optimize the use of the processors. This application will compare the Excel files and can create an output file with the final result. This application can have a progress bar to let you know how it goes while it's working. I invite you to check my profile and see the feedback left by other clients. I am available to discuss any detail via chat.
€470 EUR in 5 days
5.0 (62 reviews)
6.4
6.4
User Avatar
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. ******We will solve this problem using programming in python and also get the required data and results. Looking forward to discussion, Best Regards, Suyash
€750 EUR in 10 days
4.6 (103 reviews)
7.0
7.0
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and regards
€250 EUR in 3 days
4.7 (113 reviews)
6.3
6.3
User Avatar
Hi Christos, I can help you to merge and compare your excel files using formulas and/or VBA scripts. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets) as an Industrial Engineer at Michelin Romania . I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
€300 EUR in 4 days
5.0 (23 reviews)
5.7
5.7
User Avatar
How are you? Dear. I have just read your job post please. Indeed, very interesting. So I think both of us could discuss details about this project with each other via chatting. Look forward to you. Thanks a lot, please :).
€333 EUR in 10 days
4.9 (36 reviews)
5.3
5.3
User Avatar
Hello, I hope you are well. I can create a spreadsheet to compare data from all 3 workbooks based on VBA. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
€333 EUR in 3 days
4.9 (34 reviews)
5.3
5.3
User Avatar
Hello Cristos! My name is Lina Maira, I am very interested in your project. I am part of the preferred freelance program and I am here to give you my best offer. I understand that your files contain many records, however EXCEL 2007 is not left hanging as EXCEL 2013 does onwards. However, I think we could take the criteria by sheets. That each sheet is a criterion, and in which are the records of the 3 books. I do not know if I explain myself. In that way, the analysis of the data and the comparisons would go a little faster. I hope we can work together, my price is for all your project. I would love for you to send me, if possible, one of the workbooks to give a view. LINA
€444 EUR in 15 days
4.7 (25 reviews)
5.4
5.4

About the client

Flag of GREECE
athens, Greece
5.0
2
Payment method verified
Member since Jun 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.