Am I missing something on what this OP wants?

I think s/he wants cascading updates from a Validation Table, but I just can't understand the question.

http://www.excelforum.com/excel-form...alidation.html