Hello Guys,

I have question regarding multilevel list in Excel.

I have numbered the column as a Tree structure so for example:
T1
T1.1
T1.1.1
T1.1.1.1
T1.1.1.1.1
T1.1.1.1.2
T1.1.1.1.3
T1.1.1.2
T1.1.1.3
T1.1.1.3.1
.......

Every leaf node (the one which has no children further), so in my case T1.1.1.1.1-3 is calculated via a specific formula, lets say F1.
And every node is Max of Leaf nodes, for example T 1.1.1.1= Max(T1.1.1.1.1;T1.1.1.1.2,T1.1.1.1.3) , T1.1.1 =Max(T1.1.1.1; T1.1.1.2)...and so on

For now it is working manually. But what I am trying to do is , to automate it via VBA.
So I want to wrote a Macro which somehow could detect which one is leaf node and which one is Node or parent node and apply formulas on..

An additional feature would be if I could write this list automatically also instead of writing each number manually.

I am not very good with VBA. so i someone could help me with this would be a great help.

Thanks in advance!
Kim