multiple data validation

Fiver · Jul 25, 2009

Cell A1 requires Yes or No as a result of data validation list

Want second data validation list to then trigger in cell A2 if answer in A1
was Yes and a second one to trigger if answer was No.

suggestions please.

T. Valko · Jul 25, 2009

See this:

http://contextures.com/xlDataVal02.html

Fiver · Jul 26, 2009

Perfect! Thanks for the quick response.

T. Valko said:
See this:

http://contextures.com/xlDataVal02.html

T. Valko · Jul 26, 2009

You're welcome!

--
Biff
Microsoft Excel MVP

Fiver said:
Perfect! Thanks for the quick response.