Apologies for the poor subject heading... I don't really know how to phrase the problem
Attached is my working example.
What I am trying to do is to have dropdown lists (via data validation) change dependent on the initial list selection.
Using the example - I have already populated the first row in a table with the dropdown lists. B2 is a dropdown of country codes (listed in Col F). The dropdown list in C2 links to a filtered list (using the Filter and UNIQUE function) that returns those Regions (in tblLocation) that are in Country Code selected in B2 (which is GB).
The dropdown list in D2 links to a filtered list (using the Filter and UNIQUE function) that returns those Places listed (in tblLocation) that are in the Region selected in C2 (which is England).
This is great... but... I want, in the next row, to select different dropdown options. For example, I want to enter 'RU' in B3 and then select 'Southern Federal District’ (which would be one of the RU Region options if it worked). At the moment I cannot find a way of achieving this.
Any help greatly appreciated.