VBA programming Microsoft Excel duplicate finder

Development of a Microsoft Excel solution for finding and eliminating duplicate data records

The airline service provider Hahn Air Interline Services GmbH (Dreieich) commissioned eWorks, in cooperation with IT Pohl (Großostheim), to develop an Excel tool for comparing Excel lists and finding duplicates: the "Duplicate Checker". The objective was to program an individual Excel solution that would support process handling and increase process efficiency.

The software was developed using Microsoft Office 2003 in the form of a Microsoft Excel add-in with embedded VBA macros ("VisualBasic for Applications") in order to achieve the most cost-efficient integration possible into the client's existing IT environment on the one hand, and the easiest possible access to the Excel tables to be synchronized on the other.

A particular challenge during implementation turned out to be the size of the data records to be reconciled - many thousands of rows - which initially led to impractical runtimes, but could then be brought under control by optimizing the performance of the VBA macros.

eWorks programmed the Excel tool with Microsoft Excel and VBA, quality-assured it and handed it over to the client ready for operation. Following the handover, eWorks supported its client with the installation and use of the duplicate finder. Since then, the client's employees have been using the Excel solution to find and eliminate duplicate data records - with significantly reduced process costs.

Used technologies

VBA
Microsoft Office

Related references

Would you like to
commission a project?

Enquire now!

Are you looking
for a job?

Apply now!