Thank you, Bernard.
What if just cell D11 and D12 have a dropdown of Yes,No; only one cell can
have
a Yes answer?
--
Thank you,
scrowley(AT)littleonline.com
"Bernard Liengme" wrote:
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