Hi

I am creating a monthly time sheet, where I have a job reference (number) in column C, job name in column D and the total number of hours worked on this job in as single session in column F.

The jobs I am working on varies from month to month, so the references in column C and D will change.

Is there a way to have a small table adjacent my monthly time sheet where excel automatically lists the jobs that have been worked on in that given month, and gives a summary of the total number of hours worked on for each job for the month?

Many Thanks.