Nothing can move the users to another cell other than a VBA macro
If you are ready for this; post your Q in the programming newsgroup
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SCrowley" wrote in message
...
I have searched Contextures.com, Excel help online, and this community and
I
am baffled (been staring at this too long). I know the answer is simple,
it
just escapes me.

Excel 2007-

I have cell D11 and D12 I want a dropdown of Yes,No; only one cell can
have
a Yes answer. Then if D11 is Yes, move user to cell E15, if D12 is Yes,
move
user to cell E13. I thought I could do a Data Validation using
Custom/Formula.

I appreciate your help. Thank you!
--
Thank you,

scrowley(AT)littleonline.com