Can this be done?

[Sara Moore]

I have an already created spreadsheet that tracks which person is handling which task during each 30 minute increment. The sheet is filled in by typing in the name of the specified task into the corresponding cell for the person and the time of day. The tasks are tracked daily. I am attempting to find a way to take the data from the Mon-Fri sheets and have it automatically filter into a weekly totals sheet, broken out by each task and the total man hours that were used during the week on the particular task. Is what I'm trying to do possible? If so, how? Is there a better way to compile this data? Thank you!

 

[doofusboy]

Look into Pivot Tables....they are best suited for the tasks you describe.

 

[Sara Moore]

Thank you, I'll give that a try.