Template to track employee vacation,sick & funeral leave time?

[Mrs. Happy!]

I have Microsoft Office Excel 2003. I'm not very familiar with the program
and I need to set up of form to track individual employee's leave time. My
hopes is to have a sheet for each employee, be able to input a date, hours
requested and type of leave time (sick, vacation, or funeral) and have the
form figure the time that particular employee has left of each type of leave.
Is this possible?

 

[Susan]

yes, you can do that. do you have the spreadsheet created yet? if
not, that would be your 1st step.
choose Insert, Worksheet from the toolbar to add enough worksheets for
all your employees. design your form & copy & paste it to all your
sheets.
susan

 

[John Fuller]

Yes, it is possible.

I would suggest laying out how you want it to look on the sheets first.
IE, cell A1 is Employee name. Then A3 through A## is the date, B3
through B## is Hours off, C is type of leave, etc. You can then look
into User forms for inputting the data if you want to do that.

Also, are you sure you want a sheet for each employee? I would
probably contain it all on one sheet and just put the employee's name
as one of the columns. You can then use autofilter when you want to
look at just John Doe's leave, etc. You can then use a second sheet to
hold the data for like how much vacation, leave, sick, etc time each
employee has for the given year.

Hope this helps.