Loop Tree

[rrocker1405]

Hi,

I have a large amount of data and I'm need to pick up data like in the attached sheet. I could use index match to pick up the related items but has its own limitation and I'm stuck with this puzzle now and i think i need a vba code to run the index match to pick up this view.

Please help.

Thanks in advance.

Kind regards,
A!

 

[NARAYANK991]

Hi Anand ,

As already mentioned , this kind of hierarchical visualization is suited for a treeview control ; the main step in implementing this is to have the data in the right format ; if you can bring your data into the right format using formulae , the code is straightforward. See if you can make use of this :

http://www.excelguru.ca/content.php?194-Using-a-Treeview-Control

Narayan