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
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
Hi Tara
choose data / validation
choose list
set the source
and UNTICK in cell drop down
Cheers
JulieD
"Tara Keane" <TaraKeane@discussions.microsoft.com> wrote in message
news:181134B2-D1AA-4573-8894-9F7AC442937F@microsoft.com...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks