OK let's try to explain this simply. I have two lists, my list in column A contains Meat, Fish, Vegetable and my list in Column B contains Beef, Lamb, Cod, Haddock, Carrot, Potato. I select Meat from the drop down data validation list. How can I then reduce the drop down list in Column B to be only Beef and Lamb?