Closed

match 3 different excel workbooks and compare different values

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

Skills: Data Entry, Data Processing, Excel, Software Architecture, Visual Basic

See more: how to compare two excel files 2010, compare two columns in excel for matches, how to compare two excel sheets for differences in values, compare two excel files online, compare two excel sheets and highlight differences, how to compare two excel sheets using vlookup, how to match data in excel from 2 worksheets, excel find matching values in two worksheets, compare file different time, excel macro compare table, excel workbooks sheets update, excel macro compare tables, excel macro compare rows, compare vba code excel workbooks, excel macro cut values, compare text different files perl, match number excel, oscommerce store compare catalog different, excel average incremental values, excel spreadsheets compare filing missing information

About the Employer:
( 1 review ) athens, Greece

Project ID: #19320283

76 freelancers are bidding on average €378 for this job

seaanddream

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 wh More

€500 EUR in 10 days
(320 Reviews)
7.9
semi786

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, Su More

€500 EUR in 0 days
(387 Reviews)
8.0
schoudhary1553

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. More

€250 EUR in 4 days
(349 Reviews)
7.9
deepbluetech

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 impleme More

€300 EUR in 3 days
(257 Reviews)
7.4
zekovicm

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 de More

€388 EUR in 5 days
(135 Reviews)
7.3
P0L

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
(291 Reviews)
7.2
Dhruvika111

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-o More

€250 EUR in 2 days
(376 Reviews)
7.7
elqueabandona

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 outsourc More

€350 EUR in 3 days
(227 Reviews)
6.9
paulmd369

to match data from 3 different excel workbooks (with multiple criteria). (10.000+ rows and 20+ columns each )

€400 EUR in 10 days
(119 Reviews)
6.5
suyashdhoot

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 comp More

€750 EUR in 10 days
(73 Reviews)
6.7
periyannas

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 r More

€333 EUR in 3 days
(102 Reviews)
6.2
amranreza70

***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 More

€500 EUR in 7 days
(93 Reviews)
6.3
sonarkaushik

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 More

€250 EUR in 3 days
(112 Reviews)
6.3
diorisaguilar

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 pr More

€470 EUR in 5 days
(44 Reviews)
6.0
TechnoGuruu

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 VB More

€299 EUR in 5 days
(76 Reviews)
5.7
sajidkhan45

Hi I am an excel VBA expert and I understand your point that this job is not that easy. I have worked on many projects and this is fairly complicated. In my experience, class modules would be the best way to handle More

€250 EUR in 7 days
(48 Reviews)
5.3
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

€250 EUR in 3 days
(92 Reviews)
5.5
hemi

Hi Christos, Thanks for posting and interesting project here. I'm highly interested to working with you on this proposed project. My skill sets and prior experience are perfectly matching with the scope of this proj More

€555 EUR in 10 days
(39 Reviews)
5.1
afenache

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 formula More

€300 EUR in 4 days
(19 Reviews)
5.2
jasalaz100

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. More

€333 EUR in 3 days
(32 Reviews)
4.9