Validation Table - Entering Value not in a table

  • Thread starter Thread starter saltnsnails
  • Start date Start date
S

saltnsnails

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!
 
There is an option (Excel 2007) under data validation which allows you to
issue a warning when an item outside the list is entered.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
Vlookup dependent on a validation table 6
Indirect validation list with blank in list 3
Structured references in custom Data Validation expression? 11
Data validation accepts illegal entries when one spreads values 5
Using Table Column for Data Validation List 2
VLookup using lookup table 1
vlookup with validation table 3

Back
Top