Tracking Time Off
I am creating a database to keep track of employee absences. I used the preloaded vacation option in the preloaded templates with some modification. If I enter each day of vacation or sick leave seperately, It displays all of them with no issues. Since I have over 400 employees on site, individual data entry is not really an option.
Currently time off is maintained in SAP and exported to Excel to view. I would like to be able to use the Excel sheets to upload the data.
I am able to import the data but I am only able to see one entry on the Time off view tab. How can I get each line in excel to display on the time off tab? i am using the employee ID as the matching value and this seems to work fine. Please help.