Hi Lisa,

Go to http://www.edferrero.com/ExcelCharts...2/Default.aspx
and download 'Cascading Cell Validation' (page 2, I think)

That sample has 2 dependent levels, plus an explanation. To see a sample
with 3 dependent levels, download
http://www.edferrero.com/Content/Cas...Validation.xls

Ed Ferrero
www.edferrero.com