Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple drop down list
I need step by step assistance in setting up a dropdown list which allows
each of the items in the list to have a drop down. I have been referred to data validation, however I aparently am to dumb to understand how it is supposed to work, following the example does not five me what I need. My list needs to be dependent on cell C7 and P8. If C7="SF"and P8="1", then I need a list in cells D16:D26 which has: Base, EXT, INT, Xtra, Other and then each of those should allow a drop down to allow a selection of 4 - 9 different operations. I also need this to display in D16 or which ever cell I am in D16:D26 If someone can suggest how to get this far, I think I could add the other 3 possible scenarios Thanks for any assistance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple drop down list
flashy, Try: Dependent validation lists. Debra has a neat little tutorial here. 'Excel -- Data Validation -- Dependent Lists' (http://www.contextures.com/xlDataVal02.html) Dynamic Dependent Dropdowns Data Validation '123-reg | Domain names | Domain name registration' (http://www.xldynamic.com/source/xld.Dropdowns.html) Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125575 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple entries from a drop down list | Excel Programming | |||
Multiple Drop Down List | Excel Discussion (Misc queries) | |||
Multiple drop down list box | Excel Discussion (Misc queries) | |||
Multiple hyperlinks from drop down list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |