Using multiple drop down boxes (Value entered into box 1 dictates options present in next)

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

Hi Ethan,

Could you Upload a Sheet with Sample Data and maybe add a result sheet which shows how you want it to be.
I understand the need you have for one Dropdown reduces the next ones options but to give advice how to do it we need to know how your Data is set up.

Best would be if you have a List in a Database kind of Format Like
Column A = Country
Column B = City
Column C = Street
etc..

for the dropdown i would use a userform instead of putting the Dropdown in an excel File cause i find it kind of uncomfortable to work with and set up.
Would userform be an option for u or do you need it to be in the sheet?

Greets
Loki

Hello Loki,

Thanks for getting back to me.

Please find the very simple example doc i have attached. Essentially the information used to populate the lists could be in whatever layout/format that is necessary.

As stated before, the eventual purpose of this is to get the contents of the data entry to be saved out to a master sheet and the data entry section reset to null values. ( I guess I will address that after I have overcome the initial problem of organising the drop down lists.

Regards
Ethanrholt

Example Data.xlsx