Lukket

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

Evner: Dataindførsel, Databehandling, Excel, Software Arkitektur, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) athens, Greece

Projekt ID: #19320283

76 freelancere byder i gennemsnit €378 på dette 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 Flere

€500 EUR in 10 dage
(320 bedømmelser)
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 Flere

€500 EUR in 0 dage
(387 bedømmelser)
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. Flere

€250 EUR in 4 dage
(349 bedømmelser)
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 Flere

€300 EUR in 3 dage
(257 bedømmelser)
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 Flere

€388 EUR in 5 dage
(135 bedømmelser)
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 dage
(291 bedømmelser)
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 Flere

€250 EUR in 2 dage
(376 bedømmelser)
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 Flere

€350 EUR in 3 dage
(227 bedømmelser)
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 dage
(119 bedømmelser)
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 Flere

€750 EUR in 10 dage
(73 bedømmelser)
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 Flere

€333 EUR in 3 dage
(102 bedømmelser)
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 Flere

€500 EUR in 7 dage
(93 bedømmelser)
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 Flere

€250 EUR in 3 dage
(112 bedømmelser)
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 Flere

€470 EUR in 5 dage
(44 bedømmelser)
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 Flere

€299 EUR in 5 dage
(76 bedømmelser)
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 Flere

€250 EUR in 7 dage
(48 bedømmelser)
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] Flere

€250 EUR in 3 dage
(92 bedømmelser)
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 Flere

€555 EUR in 10 dage
(39 bedømmelser)
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 Flere

€300 EUR in 4 dage
(19 bedømmelser)
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. Flere

€333 EUR in 3 dage
(32 bedømmelser)
4.9