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