You're welcome!

--
Biff
Microsoft Excel MVP


"Fiver" wrote in message
...
Perfect! Thanks for the quick response.

"T. Valko" wrote:

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Fiver" wrote in message
...
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.