Tracking Time off in a Calandar
Currently our HR Manager tracks our Time off in a simple excel sheet but management has asked me to look into a easier way of viewing this data, hoping for a for it to show on a calendar, maybe even a excel macro showing who will be out this week that reads from a table.
Does anyone have any ideas how I might do something like this?
Does anyone have any ideas how I might do something like this?
Comments
-
taternuts666
Member Posts: 200
Do you use Outlook? You could use the Calendar function or Goggle Calendar which is essentially the same. The actual amount you have banked and such can be kept in an excel spread sheet or access database.