I have got 2 worksheets, one has got data in Tree View, what I am supposed to do is that to fill the other worksheet based on the value of every leaf-node in treeview worksheet.
Treeview data:
X>
|X1
||-a1
||-a2
||-a3
X2
||-b1
||-b2
||-b3
X3
||-c1
||-c2
||-c3
In second sheet...