treeview in excel with parent & child nodes
hi I need help to create a treelist/view in my attached workbook.
sht 1 - I have entered some data that the treeview needs to be linked to
sht 2 - is where the treeview needs to be created
- on this sht2 the default view of the treeview will show only row 2, then each row after that will be individual nodes.
- the search box on top is where I need to enter search criteria either text or numeric values or a combination of both
- once a search criteria is entered, the treeview needs to show a fully expandable treeview not just the search text value
- the search box must show how many items have been found as for example "3 items found" and these 3 items must be shown on the treeview fully expandable from row 2-7 so I can track where it has come from in the data
- the treeview needs to be done in such a way that the entries in the data sheet are unlimited so that I can add as many rows as I need to
- it needs to be operational in excel versions 2007 onwards
sht 1 - I have entered some data that the treeview needs to be linked to
sht 2 - is where the treeview needs to be created
- on this sht2 the default view of the treeview will show only row 2, then each row after that will be individual nodes.
- the search box on top is where I need to enter search criteria either text or numeric values or a combination of both
- once a search criteria is entered, the treeview needs to show a fully expandable treeview not just the search text value
- the search box must show how many items have been found as for example "3 items found" and these 3 items must be shown on the treeview fully expandable from row 2-7 so I can track where it has come from in the data
- the treeview needs to be done in such a way that the entries in the data sheet are unlimited so that I can add as many rows as I need to
- it needs to be operational in excel versions 2007 onwards
ASKER
hi Roy, thankyou... but still that article was too technical for me...are there templates that can be used for excel 2010 that i can download so that all i need to do is load my data into and that will automatically show up in a treeview?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Frank, is this the correct workbook? There is no VBA in it.
If Frank responds with more details then I'll be pleased to help
ASKER