| Rating: 0 |
| Total Hits - 19 | Hits Today - 0 | View Ratings | Add Your Rating |
| |
|
| mightymacros Dat add-in helps accounts payable staff to identify uncaptured duplicate invoices before they become duplicate payments. The tool is installed within MS Excel and offers a non-intrusive means for scanning invoice information for duplicate transactions. The tool relies on a standard set of invoice information that you upload into an Excel spreadsheet from an ERP or accounting system. The information is then uploaded into a SQL database, where it is analysed by the program and returns a report back into an Excel workbook. The SQL database that Dat add-in uses is a localDB version of SQL Server Express having around 5 times the capacity of an MS Access database. Among other advantages the localDB version does not require any configuration or administration by the user. mightymacros Dat add-in is designed for regular use, ideally to be used for validation prior to a weekly payment run. |
| https://mightymacros.net/ | Last Updated on 7/22/2019 6:46:00 PM |
| Download | Version 1.3.0 |
| View all programs for this developer |
|
| Rating: 0 |
| Total Hits - 19 | Hits Today - 0 | View Ratings | Add Your Rating |
| |
|
| mightymacros Dat Lite is an Excel-based com add-in designed to identify duplicate invoices. The tool uses invoice information from an ERP or accounting system and uploads that information into an MS SQL Server database for analysis. The solution compares all invoices against bills to be paid and the output report lists possible duplicates that are split into separate tabs based on the detection rule. In cases where an item is captured by more than one rule, the tool can update all comments across the report tabs, preventing rework. |
| https://mightymacros.net/ | Last Updated on 10/27/2019 8:59:00 PM |
| Download | Version 1.0.0 |
| View all programs for this developer |
|
| Rating: 0 |
| Total Hits - 26 | Hits Today - 0 | View Ratings | Add Your Rating |
| |
|
| mightymacros simplifies many repetitive tasks in Excel with a useful set of tools.
The utilities come with on-line help and include:
1. A shortcut organizer to store your file and folder paths.
2. A workbook multi-sheet protection tool.
3. A Multi-find tool for finding multiple items with a single click.
4. A navigation tool for large worksheets.
5. A multi-lookup tool that can return more than the first match.
6. A multi-header lookup tool that performs multiple lookups across a worksheet.
7. A multi-find and replace tool
8. A multi-filter tool that you can save and retrieve your filter criteria
9. A store text and insert text tool to save repetitive typing.
10. A bookmarks tool where you can sort and arrange sheets,
11. A Clean and trim text tool
12. Delete empty rows
13. Insert rows on changing values.
14. Show duplicates as well as all repeating values.
15. Change case
16. Edit Cells, insert, move, delete, characters and text within cells
17. A rounding number tool
18. A variety of date tools and more... |
| https://mightymacros.net/ | Last Updated on 10/27/2019 10:32:00 PM |
| Download | Version 4.4.9 |
| View all programs for this developer |
|
| Rating: 0 |
| Total Hits - 20 | Hits Today - 0 | View Ratings | Add Your Rating |
| |
|
| Automates and simplifies the installation and update process when installing VBA Excel Add-ins. The program eliminates the need of copying and pasting to the add-ins folder, checking, unchecking boxes and closing dialogs making the deployment of VBA Excel add-ins friendly and suitable for all. The program installs onto the end of the developer tab within Excel.
The program loads a file picker for selecting the Add-in to install. If Excel has an existing older version of the same add-in installed, the program will automatically replace the old add-in file. The program will prompt for a response if the installed add-in has a later date, in order to prevent overwriting a newer version. |
| https://mightymacros.net/ | Last Updated on 4/24/2020 10:38:00 PM |
| Download | Version 1.0.3 |
| View all programs for this developer |
|