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
Bookmarks