Results 1 to 1 of 1

Project Tracking Tool

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Cranfield
    MS-Off Ver
    Excel 2007
    Posts
    68

    Project Tracking Tool

    Hello All,

    I am creating a project tracking tool as there are several hundred projects to track and I need to know how long I have been working on each one.

    As you can see from the attached sample, I have made a little userform that enables you to start a new project, stop it, add favourite projects, etc.

    Sheet1 logs every start/stop action and sheet2 has all of the projects and favourites and has some helper cells to enable everything else to work!

    What I'm looking for is for the Display Project Times button on the userform to display something like what is on sheet3...taken from all of the logs on sheet1. Ideally, everything would be listed in weeks of the year by date and project. I just don't have the skill to collate all of the data like that.

    Any help/advice would be very much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a sales tracking tool
    By nsamiee in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-22-2014, 01:42 AM
  2. Simple defect tracking tool in Excel
    By ynwa88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 06:02 PM
  3. Project Tracking
    By Catherine T in forum Excel General
    Replies: 2
    Last Post: 11-21-2012, 04:33 PM
  4. How To Create a tracking tool using excel07
    By cinco5 in forum Excel General
    Replies: 0
    Last Post: 10-21-2008, 10:22 AM
  5. Project Tracking Help
    By Kiwi06 in forum Excel General
    Replies: 2
    Last Post: 04-20-2008, 02:50 PM

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