Drop-down list from drop-down list

J

jlhart76

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i enable a drop down list depending on result of "if" funct 3
drop down list 1
Validation list with formula? 3
Setting up conditional drop down lists in Excel 2003? 1
Data Validation & Dependent Lists -from same list? 5
Filtering a Drop Down List 3
Filtering forms data with a drop down box 4
Categories & Drop down boxes 1

Top