See if this helps..

You will need dynamic named ranges for the 2nd and 3rd level drop down lists

http://www.excelforum.com/excel-gene...l-entries.html