Results 1 to 14 of 14

Excel 2007 : How to create drop down list but options reducing after every seclection?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Question How to create drop down list but options reducing after every seclection?

    Hi,

    Is it possible to do a drop down list that allow user to select pre-defined selections but everytime when a selection is chosen, the list reduced?

    Example,

    I have can choose Apple, Orange, Durian and Mango.
    The drop down can only select these 4 fruits.

    So there are 4 cells in Column A1, A2, A3, A4.
    A1 selects Mango and then A2 will only have 3 options to choose. So until the last cell, he can only choose the last fruit left.

    A1, A2, A3, A4 are not selecting in descending order thus it could be A3 selecting first, then A2 and then A4.

    I'm using excel 2007. Hope someone can enlighten me. Thanks.
    Last edited by Lewis Koh; 08-22-2011 at 10:06 PM.

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