Automatically populate editable data in a cell based on dropdown list

Question

Dear Community,

I am trying to create a sheet that can autopopulate data based on the information from a dropdown list. I am aware how this can be done via Vlookup, however, I want the data to be editable.

For instance...

• Sheet 1: Cell A1 will have a drop down list (for example USA, UK)
• Sheet 1: Cell B1 need to populate the list of town as per sheet 2 and I need the list to be editable, that is I can remove, crosscheck Las Vegas or even add additional name.
• Sheet 2 will define the list as follows: A1 USA and B1 New York, Las Vegas, San Francisco A2: UK and B2 London, Manchester, Liverpool

Does this make sense? Can this be done in excel?

Answer 1

Have a look into this file how to accomplish that in Excel. It shows a formula and a VBA solution.

https://www.dropbox.com/s/hwi91qpjgh2nb8j/Cascade%20ComboBox.xls?dl=1

Andreas.