View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Dependent Validation

I have seen solutions for dependent validation, but they are for pretty
simple situations.

I have a need for four levels of validation (Pick Level 1, Options for level
2 are based on level 1, Options for level 3 are based on levels 1 and
2,....). The source file with all the options has about 1000 lines of data.
Is there a way to do these searchs on the fly?

Thanks