| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
validate data from list without picklist
Is it possible to set up validation so that it only accepts as valid the
entries in a list somewhere (Job codes) but I don't want a pick list. I just want it to reject as invalid any code entered that is not in my list of job codes |
|
#2
|
|||
|
|||
|
Hi Tara
choose data / validation choose list set the source and UNTICK in cell drop down Cheers JulieD "Tara Keane" wrote in message ... Is it possible to set up validation so that it only accepts as valid the entries in a list somewhere (Job codes) but I don't want a pick list. I just want it to reject as invalid any code entered that is not in my list of job codes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
| Add same set of formulae at defined intervals to list of row data | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
Linear Mode
