I have an employee absence tracking spreadsheet that I would like for it to make an automatic entry onto an excell calendar, whenever an entry is made for that date, but it must also be able to make that entry for a max of 3 employees out of 14. (say employee 1 takes off vacation on January 6, 7, 8, 9 & 10) it would populate my excell calendar for those dates, with employee 1's name. The tracking sheet also tracks sick leave and roving holidays, but it only needs to tell me on the calendar who is off, not what type of day they are taking off. I really want to stay with the calendar format, and not a chart or dashboard view. I have attached what I have, and would appreciate any help.Example.xlsx
Bookmarks