Ken Atigari shows how to create dependent drop down lists using the indirect and substitute syntax within data validation. He then programs with VBA to automatically return the list values to default.