Does anyone know how to do the following:

If you have a Dropdown Box in say cell A1 with Vauxhall, Ford and Mitsubishi as the options. Can you then program the dropdown box in cell B1 to just show Corsa, Vectra, Astra, when Vauxhall is selected in cell A1, and Ka, Fiesta, Mondeo if Ford is selected etc...?