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:
mightymacros Excel Utilities
- A Create sheet tabs macro that is based on column group values.
- A create workbook macro based on sheet tab names
- A double-click and filter macro.
- A count filter macro that displays counts and percentages of column values in descending order.
mightymacros AddIn Installer
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
Fast Analysis
Digs Deeper
Runs Checks
The program runs validation checks within Excel on the invoice data prior to uploading it to a SQL Server localDB database file.
SQL Logic
More than 50 SQL queries are utilized to compare invoice history with unpaid bills.
Identifies
Suspected duplicate invoices are identified and extracted by rule type to an output table ready for import into Excel.