+ Reply to Thread
Results 1 to 2 of 2

Dropdown list tracking

  1. #1
    Registered User
    Join Date
    07-25-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    1

    Dropdown list tracking

    I am using Excel as a time tracking spreadsheet.

    . I have 15 dropdown tasks items that are being used.

    . The dropdown items are stored in worksheet 2 and the main spreadsheet is in
    Worksheet 1. I have it set up so I can access the dropdown tasks from worksheet 1, even though they are stored on worksheet 2 in column A.

    . In the main tracking worksheet 1, I have the date in Column A, and from the
    15 dropdown tasks, I pick one of them that describes the task I am performing.

    I want to set up a worksheet 3 with the following information:
    . Cumulative totals of time for each of the dropdown tasks.
    . A grand total for time of all of the dropdown tasks.

  2. #2
    Registered User
    Join Date
    07-08-2011
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Dropdown list tracking

    May we see the worksheet, or at least a mock-up?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1