Work Hours Doscument

[StevenYoungGSB]

Hi all,

First time poster and feeling a little out of my depth on this one.

I've created a lot of "programs" in the past using excel to generate kit weights for buildings, generating memberships etc, but I'm at a total loss here and need help.


Essentially, what I am trying to achieve is to create a work hours template.

The user will at the beginning of the month select the first worksheet and add any jobs they have been doing, and then a time in hours against the job from Monday to Friday.

So for an example, "Allan" might be doing work on a Site called Kinross. He then marks 3 hours against it on Monday and 2 hours against it on Tuesday.

The following week, Allan goes back to working on Kinross and clocks up another 5 hours.

What I need to happen, is for a 5th page to report all the hours against each distinct job to generate a monthly report. In addition, each type of job is in it's own category. So example: I could be doing work on the site at Kinross under Sites, but also doing work on the Kit Production for Kinross as well.

Would anyone be able to help me?