I am using Data Validation on some fields to create a drop down list from a named range! These fields however allow you to enter values that are not in the list.
Is there a way to make the cell have to be an entry from the data validation list?
I am using Data Validation on some fields to create a drop down list from a named range! These fields however allow you to enter values that are not in the list.
Is there a way to make the cell have to be an entry from the data validation list?
Last edited by QCBeauty; 07-20-2009 at 01:31 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks