+ Reply to Thread
Results 1 to 2 of 2

Drop down list depend on another cell value

  1. #1
    Registered User
    Join Date
    11-22-2010
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    36

    Talking Drop down list depend on another cell value

    Hi Everyone
    I want to know how I can have only the selected list in Cell B1 based on selection in cell A1
    Example
    I have a drop down list in Cell A1 containing 3 items (Apple-Orange -Banana)
    and on the cell B1 have another dropdown list but I want to have only Green -Yellow to be selected in cell B1 when I choose Banana in cell A1
    and same for orange I need to have only Orange -Red-Blue in cell B1 when I select Orange in cell A1
    Thanks

    Bakar

  2. #2
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Drop down list depend on another cell value

    See Debra Dalgleish's site here.
    Good luck.

+ 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