Automate Your Tasks in Excel

About mightymacros

mightymacros Excel Add-ins and Utilities, provides free as well as paid MS Excel solutions to individuals and organisations that need to automate and reduce their repetitive tasks. An Excel solution can help turn MS Excel data into real information at the click of a button. 

mightymacros is the business-hobby of a retired Industrial Engineer who enjoys making MS Excel programs using VBA and Visual Basic. There is no hidden agenda, and your feedback is most welcome.

So, if you require an MS Excel solution or would like to contribute to expanding the functionality of any of the free tools available on this site then please send your message using the link below:

email mightymacros

mightymacros Excel Utilities

Simplifly many repetitive tasks in Excel with this useful set of free tools.

mightymacros AddIn Installer

Automate the installation and update process for installing VBA Excel Add-ins with this free tool.

 Identify Duplicate Invoices and Payments with mightymacros Dat Add-in

mightymacros Dat add-in used alongside an ERP or accounting system helps to easily capture and detect duplicate invoices. If you are looking for a cost effective accounts payable tool, to run and check for invoice duplicates prior to making payments, then you have come to the right place. 

Easy to use

Our solution is simple and easy to use. 

Fast Analysis

Quick to process, separate and sort duplicates. 

 Digs Deeper 

Extends the search for duplicate invoices with changes to more than one variable.

Validates and uploads the invoice data from MS Excel to a SQL Server database

Compares invoice history against unpaid bills

Appends suspected duplicates to an output table.

Extracts the duplicate items, then sorts and splits the report data onto separate Excel tabs by duplicate rule