Based on what is selected in the cell A1 (A1 has a drop down based on data validation) I would like options to be displayed in B1, B2, B3 etc. for that selection in A1 and similarly based on which cell user selects in column B, I would like to have the corresponding options displayed in Column C.

So, I have following named range:
Category:Animals, Birds, Plants
Animals: Cow, Goat, Pig
Birds:Sparrow, Crow
Plants: grape, tomato
Cow: White, Brown, Mixed

When I select Animals in cell A2 then column B will display Cow, Goat, Pig. When I seleclt Cow in Cell B1, then column C will display White, Brown, Mixed and then I can select white in column C. All selection will be highlighted (cell colour or whatever).


I am open to using data validation / formule or VBA whatever works better and is quicker to set up.

Thank you very much for your help in advance.

Jay