We help IT Professionals succeed at work.
Get Started

treeview in excel with parent & child nodes

Last Modified: 2017-11-02
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
Watch Question
Group Finance Manager
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE