creat a drop/down sub list from a main list

  • Hi
    I have no problem creating lists using Data validation and formulas...


    i want to creat a sub list from a main list...
    so when displaying an item from the main list, another sub list appear to show sub items that are linked to the main item in the main list


    however, i wnat to use only one column, not two or three columns


    yours
    hesham

    ******************
    [SIZE=6]Yours
    h [/SIZE]

    Your Help Is Highly Appreciated

  • I don't think it is possible in Excel. The only ones where I have seen dependent validation lists are with two columns.


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

  • validation


    Hi
    It is possible to have a sub list from a main list
    See this site on validation
    I haven't found the thread yet but it is there
    Hope this helps
    Jim Henderson

    Jim
    "The problem with designing vba code completely foolproof is to underestimate the ingenuity of a complete fool."


  • This might be what you're looking for.


    http://www.ozgrid.com/FreeDownloads/MatchingLists.zip



    Rich

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!