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


The solution is uncomplicated, requiring only a few simple steps in Excel. 



Fast Analysis


Quick to process, separate and sort results, by simply utilizing the resources on your personal computer.


 Digs Deeper 

Extends the search for duplicate invoices by detecting changes to more than one of the key variables.




The program runs validation checks within Excel on the invoice data prior to uploading it to a SQL Server localDB database file.


SQL logic compares invoice history against unpaid bills. 




Appends suspected duplicate invoices to an output table.




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