Okay, so I have been redesigning our time sheet for a program at work. I am brand new to excel, having used the old works spreadsheet program for years.
At the moment, I have all of the time sheets (weekly) in a workbook, and I have one sheet at the end that adds up all of hours worked into separate categories and totals them.
Where I have gotten stuck is how to write a formula so that I won't have to edit it each and every time I insert a new time sheet.
this is what it looks like at the moment:
=SUM("sheet"!"cell containing hours" + etc..)
-----
ex.
=SUM('Sept.29-Oct.5'!D22+'Oct.6-Oct.12'!D22+'Oct.13-Oct.19'!D22+'Oct.20-Oct.25'!D22+'Oct.26-Nov.1'!D22+'Nov.2-Nov.8'!D22+'Nov.9-Nov.15'!D22)
-----
Every time I add a new week into it, I have to reedit the formula. The format of the sheet remains the same every week, is there a way to allow for sheets to be added in automatically?
Ideally, I would love to have a small, persistent graph/box that has all of the hourly totals in it, that would float on top of the workbook, separate from the workbook itself instead of having a sheet at the end.
I don't know any of this is possible, but thank you for any help!
Bookmarks