troubleshooting Question

treeview in excel with parent & child nodes

Avatar of Frank .S
Frank .SFlag for Australia asked on
Microsoft ExcelMicrosoft Office
7 Comments1 Solution432 ViewsLast Modified:
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
Roy Cox
Group Finance Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros