software

I'm trying to create a timesheet that tracks category amp; 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, amp; 6 to be visible in the activity list. All lists are
saved on worksheet titled Data, with each list named quot;Categoryquot;, quot;Cquot;,
quot;Nquot; amp; quot;Tquot;.--
jlhart76
------------------------------------------------------------------------
jlhart76's Profile: www.excelforum.com/member.php...oamp;userid=30274
View this thread: www.excelforum.com/showthread...hreadid=521732Hi

Have a look he
www.contextures.com/xlDataVal02.html

Andy.

quot;jlhart76quot; gt; wrote in
message ...
gt;
gt; I'm trying to create a timesheet that tracks category amp; related
gt; activity. I've got the dropdown for the category working, but now I
gt; need a dropdown for the activity, where the list of activities is
gt; specific to the category. Example: Category list is C, N, or T;
gt; Activities for C are 1, 2, or 3; activities for N are 4, 5, or 6; and
gt; activities for T are 7, 8, or 9. If Category N is selected, I want only
gt; activities 4, 5, amp; 6 to be visible in the activity list. All lists are
gt; saved on worksheet titled Data, with each list named quot;Categoryquot;, quot;Cquot;,
gt; quot;Nquot; amp; quot;Tquot;.
gt;
gt;
gt; --
gt; jlhart76
gt; ------------------------------------------------------------------------
gt; jlhart76's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30274
gt; View this thread: www.excelforum.com/showthread...hreadid=521732
gt;