+ Reply to Thread
Results 1 to 2 of 2

drop down lists

  1. #1
    Registered User
    Join Date
    06-28-2005
    Posts
    14

    drop down lists

    hi all,
    is it possible to generate a drop down list in one cell,
    when you have chosen something from a drop down list in another cell.

    example:- i have a drop down list containing all 20 premiership football clubs.
    If i choose, Arsenal for instance, can i set it up so that in another cell a drop down list is generated containing 'Arsenal's' squad members, and the same to happen for whichever team i select in the first drop down list, showing thier squad in the second drop down list.

    hope this can be understood.

    cheers, boufant

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi boufant,

    What you're looking for is a dependent drop-down list. Please read the following article on how to do this step-by-step: http://www.contextures.com/xlDataVal02.html

+ 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