View Single Post
  #1   Report Post  
DianeMcP
 
Posts: n/a
Default Using Data Validation - how do I allow other entries

I've tried a few different settings for the Data Validation Column, and I
have been unable to allow entry of other items into the Column. I've got a
number of "Subjects" that are being used and with Data Validation I created a
pull-down list to use withn that column. However, I want to be able to add a
subject that is not in the pull-down list and I'm getting an error saying
it's not permitted.

How do I allow for subjects that are not in the pull-down - without having
to add them to the list?
--
Thanks,
Diane