Hi Experts i have a question...

I have an excel where column B has a drop down with Y,N, and NA in it in
each cell. now what i want is if option Y is chosen the control should go to
the next cell below it.

Thanks