Documentation

What is it?

Define Hierarchy Reference can automatically generate a hierarchy / parent name list in Excel that contains the parent value of an item based on its position in an indented hierarchy list.

View Demonstration Video


Utility Definitions:
General
Column Row:
The row that contains the column header names

Top Row of Hierarchy:
The first row of the hierarchy / indented list

Bottom Row of Hiearchy:
The last row of the hierarchy / indented list

Indent Value:
The character that represents the indent


Relationship
Indent Column:
The column that contains the hierarchy / indented list


Results
Hierarchy Reference Column:
The column that the hierarchy / parent names will be created in

Hierarchy Reference Value From Column:
The column that contains the names that will be used when defining the hierarchy / parent list


Apply
Select the Apply button to create the hierarchy / parent list while maintaining the Define Hierarchy Reference dialog

OK
Select the OK button to create the hierarchy / parent list but also exiting from the Define Hierarchy Reference dialog