ConnectCode Deluxe Add-In for Microsoft Excel is a collection of commonly used add ins for improving the productivity of a Excel user. The collection is derived from the accumulation of many years of experience from Excel experts and industry users.
The Deluxe suite includes the following add-ins:
Formula Report Generator - allows you to quickly and easily generate a report to display all the formulas in your Excel Workbook. You can use this to identify and rectify any problems with your spreadsheet that contains complex formulas.
Dynamic Ranges Namer - allows you to create many different types of Dynamic Named Ranges that can expand across columns or rows.
Calendar Generator - allows you to generate a real time calendar with months, date and days of week breakdown for reference purposes.
Sheet Creator and Sorter - allows you to create many worksheets and name them quickly and easily, in a sequential or numerical order. For example, you can create worksheets with the names January to December or you can create worksheets based on Years 2000 to 2020 etc. There exists many different combinations and options that you can choose from.
Random Number Generator - allows you to generate a list of random numbers and place them in a worksheet.
Conditional Row Deletion - allows you to delete rows of data based on conditions specified in a wizard. The conditions can be rows of data (where specific columns) meet certain criteria. Alternatively, with this wizard you can remove rows of data that contains error.
Duplication Report Generator - allows you to generate a report to count the duplicates and occurrences of items in your worksheet. A unique list of the data is also generated.
Scheduler - allows you to schedule macros to be executed, workbooks to be opened, or reminders to be sent out, at a specified time.