I have a situation that I hope you can help me with or at least point me in
the right direction.
I have a spread sheet where column "A" has a defind set of values
{A,B,C,D,E} and that cell has a validation set so that only those value can
be entered. Based on the entry in column A, I need to force an entry in
Column B but allow the user to enter from another set of selections
depending on the value in column A.
example:
A1 = A B1= set(F,G,H,J)
A2 = C B2= set(K,L,M,N)
Also I would like to force the user to make the entry in column "B" before
they can proceed to the next row.
Any ideas???

--
Thank you