+ Reply to Thread
Results 1 to 2 of 2

validate data from list without picklist

  1. #1
    Tara Keane
    Guest

    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. #2
    JulieD
    Guest

    Re: validate data from list without picklist

    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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1