Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    64

    Unanswered: heirarchical menus help

    I'm trying to do a bit of stuff in Excel, and it HAS to be Excel. I'm used to working with SQL Server, MysQL and Oracle, and with a background in PHP, this would normaly be easy, but I rarely use Excel.

    I have 3 columns, one contains a top level of items,the second column contains the corresponding sub-level of items, and the third a further sub-level.

    eg

    fruit apples cox
    fruit apples golden delicious
    fruit oranges clemetine
    fruit oranges tangerine
    veg potato baking
    veg potato maris


    I want to create a system of selction (drop down menu or some-such) that will allow the selection of one of the top levels, and then will create a secondary drop down to allow selection of a child level, and so on until the third level is selected, and in doing so, passes a predefined value to another cell.

    tia

    a

  2. #2
    Join Date
    Mar 2006
    Posts
    163
    This can be done with a combination of Data>Validation..., named ranges and INDIRECT.

    See the attached file.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •