Hi cbnbac,
This sounds like a cascading validation list. See if http://www.excel-user.com/2011/02/ca...ion-lists.html helps.