Running totals on different worksheet

[Clayton]

Hi,
I'm wondering if there is a way (for a non-programmer)
to keep a running total of hours in the following
situation: We have one sheet as a Master Timesheet
summary, where employees are listed in a column along the
left side, and in corresponding rows, their hours for a
given pay-period are listed under appropriate headings,
something like this:

NAME REGULAR NIGHT WEEKEND TOTAL
Employee 1 12 10 4 26
Employee 2 10 11 12 33
Employee 3 4 16 20 40
and etc.

Then, we need to be able to link these totals (per
employee) to different employee sheets that keep track of
the running total throughout the year. I'm not having
trouble with the initial linking, I know how to do that.
However, we don't save the individual pay-period Master
Timesheets for each pay-period, so each pay-period she
opens up the Master Timesheet, enters new pay-period data,
and then prints that sheet out. Seeing as we "overwrite"
the Master Timesheet data from the previous pay-period,
how do we link the new pay-period data in an accumulative
way, to the various employee sheets?
For instance, the above totals were
Employee 1 26,
Employee 2 33, and
Employee 3 40.

Now, if the next pay-period totals were exactly the
same,

NAME REGULAR NIGHT WEEKEND TOTAL
Employee 1 12 10 4 26
Employee 2 10 11 12 33
Employee 3 4 16 20 40

then the acculmulated totals would be:

Employee 1 52,
Employee 2 66, and
Employee 3 80.

So, on each Employee sheet, even though the Master
Timesheet data is going to be volitle, it is accumulated
onto the individul Employee sheets as soon as it is
entered each pay-period.
This way, throughought the year she can observe the
total hours that each employee is accumulating, and then
she will have a total number of hours worked at the end of
each year.
I know that I could set up 52 pay-period worksheets, and
52 (or whatever) corresponding links, but I am thinking
there must be an easier way.

Phew.... this is seeming somewhat convoluted, even to me
as I am typing it. But, does anyone think they can help
me?

Thanks,
Clayton

P.S. Please feel free to respond to our e-mail address,
if you'd like. Thanks again.

 

[BrianB]

I think that this is a case of using the wrong basic approach. In case
such as this I use a more "database" method where data is added to
simple unformatted table, when it is possible to use the more powerfu
features of Excel - such as pivot tables.

When changes occur, new data can replace, or be added to the bottom of
the table and the whole thing refreshed

 

[Guest]

-----Original Message-----
I think that this is a case of using the wrong basic approach. In cases
such as this I use a more "database" method where data is added to a
simple unformatted table, when it is possible to use the more powerful
features of Excel - such as pivot tables.

When changes occur, new data can replace, or be added to the bottom of,
the table and the whole thing refreshed.

Ok,
I've never used Pivot Tables, but I have seen them in
books and in Excel itself. I'll give them a look-see.
Thanks