Employee Time Sheet
Posted on 2004-10-08
I have a worksheet set up to track employees sign-in and sign-out times from the start of their shifts including the lunch breaks to the end of thier shift.
But my problem is that this sheet is disigned to track 12+ employees, but in order for me to to that I have to create 12+ sheets - which is a no-no given all that scrolling and switching bettween sheets.
I want to be able to create a drop-down list with all the employees there, that when I click on a specific employee the worksheet will change all its values based on this particular employee's work hours.
To be more especific when I enter data on "Mike" it will stay that way only for him even if I click on "John" to check his work hours.
If you need a copy of my worksheet, just tell me how to paste it here, or give me an e-mail to send it to you...
If anybody know of a template or already have this type of sheet, can you please help?
Thanks in advance!