-
Solved: drop down list forced selection
Hi,
I have an interesting question, I want to force a user to select from a drop down list based on a calculated field... Im doing a cash reconcilation, so If column B has a discrepancy the user will have to select from a drop down list.
I have a drop down list in column c that gives a user a range of reasons? Column b is a calculated field which is a result of other colums.. put simply it?s a sum of ?
Now my question is ? if there is ANY value in column b? the user MUST Choose a reason from the Drop down list in column c? if they don?t then excel Must prompt them to do so?. What is the best way to solve this problem?? i tried data validation.. but it doesnt work... I would appreciates anyones professional expertise.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules