View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fras_too fras_too is offline
external usenet poster
 
Posts: 4
Default Drop Down List Filters

I've got a three tier dependent list set up for:
Division / Group / Line. (Thanks Debra Dalgliesh)

If a user selects a division, group and line there are no issues. However,
after selecting all three fields, I've had some users go back and change the
contents of the Division. When they do this - it makes the content of
Group and Line not make sense. Is there a way to 'blank out' the group and
line
lists if the division list is entered/changed? or to force the user to
re-enter group and line if division was changed.

thanks in advance