Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data Validation
Resolved · Medium Priority · Version 2003
Reply Wed 2 Feb 2011, 20:27Delegate Olivier said...
Olivier has attended:
Excel Intermediate course
Excel Advanced course
Data Validation
Hi,
In a simple worksheet (Excel 2003), I'd like to add a rule such that:
If a cell is completed
THEN
other cell(s) in the same column must be completed.
e.g. a pop-up message appearing upon completion of initial cell
or
completion of initial cell creates rule whereby completion of subsequent cells is mandatory
Is the latter (mandatory) option possible? If not, what is best way to encourage data entry in subsequent cells?
Many thanks
Olivier
For upcoming training course dates see: Pricing & availability
RE: Data Validation
Hi Olivier, thanks for your query. A professional solution to this problem would almost certainly involve some code to capture cell changes and alter the properties of subsequent cells accordingly. However, you might be able to achieve a similar result by using conditional data validation and dependent drop downs. There is a good walkthrough of these at this link:
http://blog.contextures.com/archives/2010/10/11/excel-conditional-data-validation/
...and I would set up the dependent drop down boxes, thereby driving the user to pick from certain lists (I would create lists with 0 entries to pick from when a user was not meant to put anything into a cell) and then protect the whole worksheet, preventing ad hoc data entry. All this will involve a certain amount of work but it can be done.
Hope this helps,
Anthony
Thu 17 Feb 2011: Automatically marked as resolved.
|