Hi,
I have a requirement which has 2 lists to be populated automatically. The
2nd list value is based on the 1st list. For eg:

1st List 2nd List
Fruits (Should display list of all fruits mentioned)
Vegetables (Should display list of all veg mentioned)
Frozen Items (Should display list of all frozen items mentioned)

If i select fruits, it should display only fruits. I have tried to other
sites ( http://www.contextures.com/xlFunctions02.html) but there is a bug in
it. It does not clear the previous values from the second list.

Can someone help, with examples..Appreciated