Making a "list"

[Dolemitefunk]

Hi everyone,

I am trying to make a minimizable list in Excel. For example Lets say I have this data set:

Grocery</SPAN>	Product</SPAN>	Product Type</SPAN>
Fruit</SPAN>	Apple</SPAN>	Granny</SPAN>
Fruit</SPAN>	Apple</SPAN>	Macintosh</SPAN>
Fruit</SPAN>	Orange</SPAN>	Florida</SPAN>
Fruit</SPAN>	Orange</SPAN>	California</SPAN>
Veg</SPAN>	Carrot</SPAN>	Baby</SPAN>
Veg</SPAN>	Carrot</SPAN>	Full</SPAN>
Veg</SPAN>	Greens</SPAN>	Collard</SPAN>
Veg</SPAN>	Greens</SPAN>	Spinach</SPAN>
Dairy</SPAN>	Milk</SPAN>	2%</SPAN>
Dairy</SPAN>	Milk</SPAN>	1%</SPAN>
Dairy</SPAN>	Yogurt</SPAN>	Greek</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

I would like to have a list like this

Fruit
Veg
Dairy

And when I click on fruit I get

Apple
Orange

And when I click on Apple I get the Apple types.

Is this possible? I would even be ok with a minimize buttonlike on the Explorer Folders.

Any help would be greatly appreciated

 

[kevatarvind]

you can use data validation using Define Name Range

CHECK FILE LINK

http://www.mediafire.com/?ey9pwiy33c10tci

 

[Dolemitefunk]

you can use data validation using Define Name Range

CHECK FILE LINK

DATA VALAIDATION.xlsx

Excellent, Thank you!