I would like extract time spent on a case and post the time entered in relation to that case into a separate spreadsheet so I can see how much time has been spent on each case over the duration of the case.

I have a team of 36 that enter time spent on a case on a daily basis onto a monthly timesheet.

The case name is entered in column C and then the time spent on the case is enterered into columns D to AH. Column D being the 1st of day of the month and so on to Column AH being the 31st of the month.

What I need to do is have a running total of the time spent on each case. However the timesheet in use is locked and so I can't auto filter the information plus the auto filter would only work on a month by month basis.

My current solution is to use Paste link and then use the autofilter but I am wondering if there is not a better way to get the information I need. Any help you can give would be appreciated.

If the above is not clear please let me know!

Thanks

Eve