Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving excel data that is changed weekly
I am using an employee payroll excel workbook. Every week I change the week
and the hours, which in turn changes the check stubs. I also have added a totals sheet to this workbook. How do I make the totals page, total each week, with out having to copy and past? I want to have a Year to date page and the template did not include this. |
#2
|
|||
|
|||
Kaye -
Does your template allow you to add additional sheets? If so, I would recommend a separate worksheet for each week of the year (this will allow you to look back at any given week should the need arise), and then another worksheet to sum the totals of each week. If you need additional help, please send me an email. - Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |