| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Drop-Down lists
Question: I have created my drop-down list (under DataValidation). What I would like to do is to populate a following field after making a selection from my drop-down list. Example: If column *A1* contains "Group A, Group B, Group C" in a drop-down list, and you choose "Group A", then I was column *-B1-* to populate a list of drop-down names for _only_ people in "Group A". Any inputs/ideas would be greatly appreciated! Regards, Giancarlo -- gtanti ------------------------------------------------------------------------ gtanti's Profile: http://www.excelforum.com/member.php...o&userid=34232 View this thread: http://www.excelforum.com/showthread...hreadid=539868 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Populating Drop-Down lists
Grancarlo, see if this will work for you,
http://www.contextures.com/xlDataVal02.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "gtanti" wrote in message ... Question: I have created my drop-down list (under DataValidation). What I would like to do is to populate a following field after making a selection from my drop-down list. Example: If column *A1* contains "Group A, Group B, Group C" in a drop-down list, and you choose "Group A", then I was column *-B1-* to populate a list of drop-down names for _only_ people in "Group A". Any inputs/ideas would be greatly appreciated! Regards, Giancarlo -- gtanti ------------------------------------------------------------------------ gtanti's Profile: http://www.excelforum.com/member.php...o&userid=34232 View this thread: http://www.excelforum.com/showthread...hreadid=539868 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have hierarchial drop down lists in Excel | Excel Worksheet Functions | |||
| drop down lists | New Users to Excel | |||
| Drop Down Lists | Excel Worksheet Functions | |||
| Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
| Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
Hybrid Mode
