Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop-down list from drop-down list
I'm trying to create a timesheet that tracks category & related activity. I've got the dropdown for the category working, but now I need a dropdown for the activity, where the list of activities is specific to the category. Example: Category list is C, N, or T; Activities for C are 1, 2, or 3; activities for N are 4, 5, or 6; and activities for T are 7, 8, or 9. If Category N is selected, I want only activities 4, 5, & 6 to be visible in the activity list. All lists are saved on worksheet titled Data, with each list named "Category", "C", "N" & "T". -- jlhart76 ------------------------------------------------------------------------ jlhart76's Profile: http://www.excelforum.com/member.php...o&userid=30274 View this thread: http://www.excelforum.com/showthread...hreadid=521732 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop-down list from drop-down list
Hi
Have a look he http://www.contextures.com/xlDataVal02.html Andy. "jlhart76" wrote in message ... I'm trying to create a timesheet that tracks category & related activity. I've got the dropdown for the category working, but now I need a dropdown for the activity, where the list of activities is specific to the category. Example: Category list is C, N, or T; Activities for C are 1, 2, or 3; activities for N are 4, 5, or 6; and activities for T are 7, 8, or 9. If Category N is selected, I want only activities 4, 5, & 6 to be visible in the activity list. All lists are saved on worksheet titled Data, with each list named "Category", "C", "N" & "T". -- jlhart76 ------------------------------------------------------------------------ jlhart76's Profile: http://www.excelforum.com/member.php...o&userid=30274 View this thread: http://www.excelforum.com/showthread...hreadid=521732 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Drop Down List | Excel Worksheet Functions |