Dynamic Named Range Index Sheet Creator.

This Excel Named Range Excel Add-in will allow you to easily and quickly create and manage all Excel named ranges and constants. You can delete all redundant or broken names, create named constants, dynamic named ranges (ideal for charts and Pivot tables), create Worksheet level names, consecutive named ranges and more.

By simply clicking a button the Name Manager will add a Worksheet to your Workbook that will list ALL your named ranges. Along with the Refers to range of each name, there is also a clickable Hyperlink for each. The index that is created is dynamic and will automatically update each time you select the Worksheet. In other words, you simply add the sheet once and it will keep up-to-date with all added/deleted names in the Excel Workbook.