MUSASHI
10-24-2004, 08:23 AM
so far so good!
I have a workbook with an employee list, and various others, plus a sheet for every day of the week. Monday - Sunday.
Once I open my book, I update any employees added to rolls via a userform, then I select sheet named for day of week to enter time. On daily sheet, I set date (via a neat calendar control which by the way, needs some work to make sure that if they are on Mondays sheet, they pick a Monday!!!!!), then I select an employee from another neat userform which places the employee# in the selected cell, the row directly below that row references the number and places the employee name(woot, big time saver, and accuracy improvement).
As a kicker, we categorize the hours worked by "cost Code" in columns, and sum up daily ttl hours..
How can I sum the data, employees in rows, and cost code for the 7 days of the week ?
:confused:
Musashi
I have a workbook with an employee list, and various others, plus a sheet for every day of the week. Monday - Sunday.
Once I open my book, I update any employees added to rolls via a userform, then I select sheet named for day of week to enter time. On daily sheet, I set date (via a neat calendar control which by the way, needs some work to make sure that if they are on Mondays sheet, they pick a Monday!!!!!), then I select an employee from another neat userform which places the employee# in the selected cell, the row directly below that row references the number and places the employee name(woot, big time saver, and accuracy improvement).
As a kicker, we categorize the hours worked by "cost Code" in columns, and sum up daily ttl hours..
How can I sum the data, employees in rows, and cost code for the 7 days of the week ?
:confused:
Musashi