Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Table - Entering Value not in a table
I have a Validation table on my timesheets that my employees record a
pre-entered activity from a validation table to decribe what they did during a certain time frame. From time to time, there will be special exceptions that the employee needs to enter a value that is not in the validation table. Is there a way to have a cell in the validation table that will accept data entry that is not present in the table? Thanks! -- -CRM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Table - Entering Value not in a table
There is an option (Excel 2007) under data validation which allows you to
issue a warning when an item outside the list is entered. "saltnsnails" wrote: I have a Validation table on my timesheets that my employees record a pre-entered activity from a validation table to decribe what they did during a certain time frame. From time to time, there will be special exceptions that the employee needs to enter a value that is not in the validation table. Is there a way to have a cell in the validation table that will accept data entry that is not present in the table? Thanks! -- -CRM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Table - Entering Value not in a table
DataValidationError Alert
Uncheck "show error etc." Gord Dibben MS Excel MVP On Thu, 21 Aug 2008 11:15:03 -0700, saltnsnails wrote: I have a Validation table on my timesheets that my employees record a pre-entered activity from a validation table to decribe what they did during a certain time frame. From time to time, there will be special exceptions that the employee needs to enter a value that is not in the validation table. Is there a way to have a cell in the validation table that will accept data entry that is not present in the table? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Entering Variable in a Pivot Table | Excel Discussion (Misc queries) | |||
vlookup with validation table | Excel Discussion (Misc queries) | |||
entering data to table | Excel Worksheet Functions | |||
I have a validation box on one page and a table on the other how . | Excel Discussion (Misc queries) |