Forum Discussion
Summarising data from individual sheets
Hi,
I have created a summary table looking at staff overtime with a different staff name on each row down the left hand side. I then have a tab name for each staff member and this is where I enter the data. I want to pull the data from the staff members tab through to the summary table. I know how to do this individually (='Joe Bloggs'!B14) but there is a lot of tabs and I don't want to have to do this for each one. Is there a quicker way? I thought I could link the staff name in the summary sheet to the tab name but I'm not sure how to do it. Thanks in advance
Hannah
2 Replies
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?
