Making a timesheet with project overview

[ojohnsen]

Hi there.

I apologize if I'm in the wrong forum here, but I would guess that "Programming" is the right place to be.

I'm making a timesheet for my job, where I'm keeping track of how many hours I've worked on a given project. On the selected date, the project can be selected from a pull-down menu, and a number of hours can be entered in the cell next to it. The pull-down menu is filled from a project list in a separate sheet in the workbook. I've attached an example of the timesheet.

Needless to say, the list will get pretty cluttered when the month's over. So I want to make a list at the bottom which sums up all the projects and how many hours that have been worked on each project. This can of course be done manually, but I wanted to know if there's a (somewhat) easy way to do this automatically. While I've programmed both C and C++, I've never programmed VBS before, so I'm completely at a loss here.

EDIT: Forgot to add the file... *facepalm*

[royUK]

There's no workbook attached

[ojohnsen]

There's no workbook attached

*facepalm* Sorry about that...

EDIT: Added the file to the original post.

[ojohnsen]

Is there anybody who knows something about this?