Đã Đóng

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

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) athens, Greece

ID dự án: #19320283

76 freelancer đang chào giá trung bình €378 cho công việc này

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 Thêm

€500 EUR trong 10 ngày
(320 Nhận xét)
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 Thêm

€500 EUR trong 0 ngày
(387 Nhận xét)
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. Thêm

€250 EUR trong 4 ngày
(349 Nhận xét)
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 Thêm

€300 EUR trong 3 ngày
(257 Nhận xét)
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 Thêm

€388 EUR trong 5 ngày
(135 Nhận xét)
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 trong 3 ngày
(291 Nhận xét)
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 Thêm

€250 EUR trong 2 ngày
(376 Nhận xét)
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 Thêm

€350 EUR trong 3 ngày
(227 Nhận xét)
6.9
paulmd369

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

€400 EUR trong 10 ngày
(119 Nhận xét)
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 Thêm

€750 EUR trong 10 ngày
(73 Nhận xét)
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 Thêm

€333 EUR trong 3 ngày
(102 Nhận xét)
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 Thêm

€500 EUR trong 7 ngày
(93 Nhận xét)
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 Thêm

€250 EUR trong 3 ngày
(112 Nhận xét)
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 Thêm

€470 EUR trong 5 ngày
(44 Nhận xét)
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 Thêm

€299 EUR trong 5 ngày
(76 Nhận xét)
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 Thêm

€250 EUR trong 7 ngày
(48 Nhận xét)
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] Thêm

€250 EUR trong 3 ngày
(92 Nhận xét)
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 Thêm

€555 EUR trong 10 ngày
(39 Nhận xét)
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 Thêm

€300 EUR trong 4 ngày
(19 Nhận xét)
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. Thêm

€333 EUR trong 3 ngày
(32 Nhận xét)
4.9