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


    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!

    (retired Excel 2003 user, 3.28.2008)

  • validation

    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

    "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.


    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!