Change the validation list in one drop-down dependent upon the selection in another

[Sisyphus]

The attached workbook has the entire set-up required to create two drop-down lists where the second one takes on a different list to select from dependent upon which selection was made in the first. Everything is explained by example of the case created in the workbook. Note, however, that you can substitute absolute cell and range references for the named ranges used in the example should you not be comfortable with named ranges.