If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running totals on different worksheet
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. |
#2
|
|||
|
|||
Running totals on different worksheet
-----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. --- Message posted from http://www.ExcelForum.com/ . 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 |
Thread Tools | |
Display Modes | |
|
|