i have 6 level of data set with sub categories for each of the as sample below.

tree listing for data validation.xlsx

defined names are not allowed with spaces. so i could not list the level data for tree listing which is for data validation into another sheet. In another sheet i should have 6 level list from which i have to select data accordingly from drop down list. how to list the data now. Any help from the expert would help me a lot to learn something about tree listing.