I am creating something on excel.


I have created a drop down box for a couple of columns, but i want to do it, where when i select something from the drop down box, i want it to change what is available in other drop down boxes.

e.g. B2 - Select option 1, certain things available in other drop down boxes
and then if i select option 2, the values in the other drop down boxes are different to option 1

hope this makes sense, quite hard for me to explain