Hi,

I´m using drop down menus for users to make certain selections. The first dropdown list refers to column A in the array, the second to B and so on. What I want to do is to dynamically update the "downstream" dropdown lists as the user updates their selections.

For example. If column A is Continents, B is Countries and C is cities. If the user selects "Europe", the second dropdownlist should discard all countries outside of Europe and only display the countries in Europe.

The reason I want to do this is that there are thousands of cities column C (some of which everyone knows what country they´re in, some not so obvious) and it´s important that the user doesn´t get huge drop down lists all the times.

The final step will be to return a reference code for each city.

I´ve been banging my head against the wall with this problem for the past week and just realised the method I have been using won´t work. Due to the people that will be using the program, it has to be written in excel.

Any help is much appreciated.

Thanks
Magsy