Question

Locked

Excel 2003 Carry over running total across worksheets

By pino ·
I created a timesheet for employees hours and wages. The bottom of the sheet has the week's total wages. I create a new worksheet for each subsequent week by copying the previous worksheet. How can i get the new worksheet to show a runniong total of all the wages from the previous weeks automatically.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

you would need to link to the previous worksheet.

by jdclyde In reply to Excel 2003 Carry over run ...

Just to be clear, you are using multiple tabs in the same file, not separate files, right?

A field in each tab that has the running total would need a formula like this:

=sheet1:sheet26!b1

That would do a sum of the range of that single cell, on each tab, and give you the total to that point. for this example, the formula is in cell a1.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums