    |
All in one Tool is developed completely into VBA and it is used to fulfill all the requirements and tasks in excel which is not possible to achieve directly, and make life easier for you.
No Installation Require.
New Features
| Tool Version | Macro Number | Macro Description | Tutorial |
|---|---|---|---|
| 1044 | 120 | Smart comparison Tool | Click Here |
| 1.027 | 119 | Custom Email (Various Method) | Click Here |
| 1.022 | 115-118 | List out File and Folder Information | Click Here |
| 1.021 | 114 | PDF to Excel (Beta) | Click Here |
| 1.021 | 113 | Export Data into Sheet and Files | Click Here |
| 1.015 | 113 | Export Embedded File from Excel File (Beta) | Click Here |
| 1.014 | 112 | Consolidate Data (42 Methods) (Click to see detail) | Click Here |
| 1.005 | 111 | UnProtect All Sheets With Password | Click Here |
| 1.005 | 110 | Protect All Sheets With Password | Click Here |
| 1.005 | 109 | Remove All Tab (Sheet) color | |
| 1.005 | 108 | Insert Comment as per Value | Click Here |
| 1.005 | 107 | Remove Blank Cell from right side | Click Here |
| 1.005 | 106 | Remove all Non Numeric Values from selection | Click Here |
| 1.005 | 105 | Remove all numbers from selection | Click Here |
| 1.005 | 104 | Export/Save each sheet as a separate excel file (Use Macro 113) | |
| 1.005 | 103 | Extract List of all Sheets with home page link | Click Here |
| 1.005 | 102 | Extract List of all Sheets | Click Here |
| 1.005 | 101 | Unhide all sheets from the Active workbook | Click Here |
| 1.005 | 100 | Get Detail of All macros | Click Here |
| |
Download Previous Version
| Tool Version | RELEASED DATE | Updates | DOWNLOAD |
|---|---|---|---|
| 1.044 | 28.02.2021 | Smart Comparison Tool | |
| 1.029 | 19.02.2021 | Improved Custom Email New Line (Linebreak) work in Email. Folder Location Cleared Improved in Export from Data Table to File Equal Column size after Export | |
| 1.027 | 17.02.2021 | Create Custom Email | |
| 1.021 | 10.02.2021 | Consolidate data and Export Data | |
| 1.015 | 04.02.2021 | Corrections in Errors | |
| 1.014 | 03.02.2021 | Corrections in Errors | |
| 1.005 | 19.01.2021 | Macro Code Descriptions 100 List of All Macro Detail 101 Unhide all sheets from the active workbook 102 List of all Sheets 103 List of all Sheets with home page link 104 Save each sheet as a separate excel file 105 Remove all numbers from the selection 106 Remove all Non Numeric Values from the selection 107 Remove Blank Cell from the right side 108 Insert Comment as per Value 109 Remove All Tab (Sheet) color 110 Protect All Sheets With Password 111 UnProtect All Sheets With Password |