Highlight duplicates, create a unique list, generate a summary report, compare lists and best of all, prevent further duplicates. Change your formulae references from Absolute to Relative and vice versa. Works on Selection, Active sheet or the entire Workbook. Sheet Index add-in will create an Index sheet of all sheets in your Workbook. Additional option allows you to create a link back to Index link on all sheets. This is 8 add-ins in one. It can sort sheets and create pre-named sheets. Easily create 8 different types of dynamic named ranges.