Hi everyone...
I have adopted an attendance trcking spreadsheet from MS Online Templates.
I have individual tabs for each person, and at the bottom of each persons worksheet has absences by month totals.
Each employees tab has their month totals in the same cell....G119 is january absences, H119 february, etc....
My summary page of all employee absences is not updating as I am not sure what formula to use. Any ideas on how I can select G119 from all worksheets and keep the formula working if I add a new employee.
Thanks in advance!
Here is the template I am using....
http://office.microsoft.com/en-us/te...CT101425551033
Bookmarks