Validation Table - Entering Value not in a table

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!
 
S

Sheeloo

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

Setting column width in a table with a macro is not working 0
"Compile error in table level validation expression " after format 0
Using Data Validation in a Table 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Create a chart from a table in word thats dynamic 0
Doughnut Chart linked with the slicer in the pivot table 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Insert Index into a Table 1

Top