Forum Discussion
Summarising data from individual sheets
Another way altogether for you to do this would involve keeping the records all on one sheet (differentiating, obviously, by a name on each row, or better yet, an employee ID if it's short and something you remember), and using the Pivot Table capability of Excel to create the summary.
I'd be happy to create an example for you, but to do so in the most helpful way, it would help me if you could post a sample (with no identifiable data) of how you keep those individual records. A sample of two or three employees (anonymous) and your summary would be ideal.
OR, let me know: do you just enter the hours worked--and do you do so on a daily or weekly basis? Or do you simply enter the OT hours, and again, do you enter this daily or weekly? Finally, is the summary a weekly one, or monthly?