+ Reply to Thread
Results 1 to 2 of 2

Making pick list conditional on selection from previous pick list

  1. #1
    Stewart
    Guest

    Making pick list conditional on selection from previous pick list

    I would like to know how to make a pick list (a "list" of names) conditional
    on what was picked in the previous column pick list (e.g. of the 4 main areas
    of a plant (pick list/ column A), there are anywhere from 3 to 5 sections
    within each main area. I would like to format/program the second pick list
    (coumn B) to only show the list of sections corresponding to the 'main area'
    selected in column A. Then I need to do this for a third pick list (specific
    equipment). If you have an example, it would be appreciated.
    Thank you.

  2. #2
    Norman Jones
    Guest

    Re: Making pick list conditional on selection from previous pick list

    Hi Stewart,

    See Debra Dalgleish's Dependent List page at:

    http://www.contextures.com/xlDataVal02.html

    See also XlDybnamic's page on Dependent Dropdowns:

    http://www.xldynamic.com/source/xld.Dropdowns.html


    ---
    Regards,
    Norman



    "Stewart" <Stewart@discussions.microsoft.com> wrote in message
    news:6D21093C-417F-4918-A921-A0F49666E8B7@microsoft.com...
    >I would like to know how to make a pick list (a "list" of names)
    >conditional
    > on what was picked in the previous column pick list (e.g. of the 4 main
    > areas
    > of a plant (pick list/ column A), there are anywhere from 3 to 5 sections
    > within each main area. I would like to format/program the second pick list
    > (coumn B) to only show the list of sections corresponding to the 'main
    > area'
    > selected in column A. Then I need to do this for a third pick list
    > (specific
    > equipment). If you have an example, it would be appreciated.
    > Thank you.




+ 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