Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bespoke drop down list
Hi all, in cell A1, I will enter Dept1, Dept2 or Dept3 in cell B1 I would like to have a drop down list, but the choices in the list would be determined by which Dept number is in A1 This would save me having to choose from a long list every time. for simplicity, the choices for Dept 1 could be red, yellow, green Dept 2 could be red, blue green Dept 3 could be Blue, purple white Can this be done, please? thank you -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=559241 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bespoke drop down list
robert111 wrote: Hi all, in cell A1, I will enter Dept1, Dept2 or Dept3 in cell B1 I would like to have a drop down list, but the choices in the list would be determined by which Dept number is in A1 This would save me having to choose from a long list every time. for simplicity, the choices for Dept 1 could be red, yellow, green Dept 2 could be red, blue green Dept 3 could be Blue, purple white Can this be done, please? thank you -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=559241 Hi Robert, There is an excellent guide to dependent lists on this page: http://www.contextures.com/xlDataVal02.html Regards, Bondi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list of a drop down list | Excel Worksheet Functions | |||
Conditional Drop Down List | Excel Discussion (Misc queries) | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |