OzGrid Excel Plus Add-in is an add-ins in one. It can sort sheets
and create pre-named sheets. Easily create 8 different types of dynamic named
ranges. Generate a report of all formulae. Create live calenders, generate random
numbers, run macros on pre-set times and much more. Come with the FREE File Size
Reducer.
This one add-in can do all of what is listed below:
Formula Report Generator
Allows you to very easily create a report showing formulas within your Workbook
that are either external references, internal references or both. You can also
nominate which Worksheet(s) to use to base your report on.
Dynamic Range Namer
This will allow you to very quickly and easily create any one of eight different
types of dynamic ranges that will expand down rows or across columns. You can
even nominate the column or row to use as the criteria. It can also expand automatically
each day month or week.
Real Calendar
This one will create a live calendar in an instant using real dates, so you
can reference it if needed. The current day is always highlighted and updates
automatically.
Sheet Creator and Sorter
This option will create any number of pre-named worksheets which can be Financial
Years (1901-2050), Weekdays (Monday-Sunday), Months (January-December), Years
(1901-2050), Quarters (Quart1-Quart4), Days (Day1-Day1460) and Weeks (Week1-Week208).
It also has an option that allows you to Sort (ascending or descending) any
Worksheets in any Workbook.
A Random Number Generator
This can produce up to 1000 non repeating random numbers that meet a criteria
you specify.
Conditional Row Deletion
This one will save many hours of repetitive work when you need to quickly and
easily delete rows in a Worksheet that meet any criteria. There is an option
that allows you to easily nominate any one of Excels six Error Types, or all
of them. There is also a simple option that allows you to nominate the criteria.
Duplication Report
Will produce a statistical table of your data. Including a Count of occurrences
of each item, the total number of duplicates and a total of all entries. It
will also produce a list of your data containing only unique entries. Better
than a Pivot Table in a single click.
Do On Time
This feature allows you to run a macro (recorded or written) at a set time,
display a personal message or reminder at a specified time or even open a nominated
Workbook at a set time.
You will be able to download the product immediately after ordering!>
|
