+ Reply to Thread
Results 1 to 5 of 5

dependent list

  1. #1
    Registered User
    Join Date
    05-27-2009
    Location
    sydney, australia
    MS-Off Ver
    Excel 2003
    Posts
    21

    dependent list

    I have seen in the forums where lists are created by refering to column values in other worksheets.If you create a list by entering text values can you make other lists dependant to those values and can those lists also be made up of text lists?
    Attached Files Attached Files
    Last edited by jloyzaga; 05-27-2009 at 10:50 PM. Reason: add attachment

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

    re: dependent list

    Hello jloyzaga, and welcome to the forum.

    Yes, you can create dependent lists, and here's the place to learn how, step-by-step: http://www.contextures.com/xlDataval02.html

    For an introduction to Data Validation, which is how you create the dependent lists, see this page first: http://www.contextures.com/xlDataVal01.html

    Hope that helps!

  3. #3
    Registered User
    Join Date
    05-27-2009
    Location
    sydney, australia
    MS-Off Ver
    Excel 2003
    Posts
    21

    re: dependent list

    But it uses values that are in other worksheets - If you look at my attachment I use lists which use text values directly and not from a worksheet. I'm wondering how to make a secondary/sub list dependant on each value selected
    so say if text value "A" is selected in list 1 then this only allows the list for "A" to be available for list 2 in its corresponding cell (the next one along)

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

    re: dependent list

    I'm not aware of the ability to do that. I'd recommend just putting your dependent lists into a worksheet (even a hidden one, or way off to the side on a visible one) and reference those lists for dependency.

  5. #5
    Registered User
    Join Date
    05-27-2009
    Location
    sydney, australia
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: dependent list

    its possible in excel 2003 - look at attachment. I use the worksheets as data drivers for automated testing and each cell corresponds to an input parameter. Each Worksheet corresponds to a regression test Function so No worksheet should have hidden data as they will be "Processed" as input parameters for each test - no go.

+ 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