I need to creat a hierarchical structure in Excel

August 11, 2013 at 22:16:57
Specs: Windows 7
I need to creat a hierarchical structure in Excel that will allow me to hide a number of rows with the click of a single icon and reveal them the same way. This will allow me to create a maintenace structure and then find the various items without having to look through the whole list.
For instance one might have "Drivetrain" with "Engine" and "Gearbox" as subsidiaries and then under "Engine" one would go into "Pistons" and so on, while under "Gearbox" one would go into "Gears" etc.
As you can appreciate, by the time you have listed all the parts on a truck, you are dealing with a long list.

See More: I need to creat a hierarchical structure in Excel

Report •


#1
August 12, 2013 at 10:03:23
It would help if your provided some more detail as to what you are looking for.

Are you looking to create "dependent drop down lists" where the contents of each subsequent list is dependent on what was chosen in a previous drop down? As each drop down choice is made, the next drop down is populated only with the items related to the previous drop down choice. When the final drop down list item is chosen, all of the information about that item can be extracted with a function such as VLOOKUP or INDEX.

If you are looking for something like that, see here:

http://www.contextures.com/xlDataVa...

If you are looking for something totally different, please provide some more detail.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question