I work for a company with retail stores grouped into regions and smaller districts.
Let's say region number 1 consists of 3 districts - # 123, #234, #345
Each of those districts contains multiple stores
#123 - stores x, y, z
#234 - stores a,b,c
#345 - stores d,e,f
I want to be able to create a list of districts/stores based on a user inputs. I already have data validation lists set up so that a user can select a particular region and further select a particular district that belongs to that region, and further select stores that belong to that district.
If user selects Region 1 in the first data validation I need a separate list to populate as below as:
# 123
# 234
# 345
If a user then selects district # 123 from the second data validation I need a list of stores belonging to that district to populate as:
x
y
z
Is this possible?
Here's how the final spreadsheet looks with the 3 data validation drop downs:
\1
Bookmarks