I have a validation list of 11 available names in column A; Potato, Onion, Carrot, Parsnip, Apple, Orange, Pear, Banana, Kiwi, Chicken and lamb. There are 3 groups; Vegetables, Fruits and Meat. There are 4 Vegetables, 5 Fruits and 2 different types of meats. If Orange is the name selected from the validation list in cell A1, the list available in cell B1 (Column B) should only be the remaining 4 fruits (Apple, Pear, Banana and Kiwi.) If Chicken is selected in cell A2, then only lamb should be available to select in cell B2. How do I get column B lists to be dependant on what is selected in column A?? How do I do this??? Please Please Help!!!