Afternoon all,

I am looking to come up with a spreadsheet that allows the user to enter information into a Data_input sheet which will then populate a Data_Master sheet with each piece of info along a single row.

The issue i am having is with creating custom lists of options to populate dropdown boxes.

I.e Dropdown box1

Select Country
UK
Germany
France

If Germany is selected Dropdown box 2 contains only the following options:

Select City
Munich
Berlin
Hamburg

Please advise the best way to achieve this.
Additionally is it possible to also incorporate this technique into a series of tick boxes? or at least a dropdown list that allowed multiple selections. (replacing dropdown box 2 with a series of tick boxes that are only relevant to the answer in dropdown box 1)

Thank you all in advance.

Regards
Ethanrholt