Dependent Lists in Excel

Discussion in 'Software' started by DAZ4518, Sep 20, 2012.

  1. DAZ4518

    DAZ4518 Private E-2

    Hi all,

    With excel file I am trying to create a dependent list from 1 of 3 possible cells that the first option is chosen from.

    It is related to my work, so the first cell is to choose an appliance type (eg: cooker, washing machine, etc) then the second allows you to select a manufacturer that makes that appliance type but I am stuggling to get excel to read all 3 cells for the dependent list. Is there any way to do this?

    If you need a copy of the file for reference, I can provide this as I am currently unable to upload it here :(
     
  2. DAZ4518

    DAZ4518 Private E-2

    Just tried to upload again and it now works, here is the file :)
     

    Attached Files:


MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds