Hi All,
I spend hours a week manually changing the default roster when employee's do any overtime or call in sick.
I normally have a roster for the whole year send this to staff on weekly basis with what they are doing. When ever someone is sick or does any overtime, i find the date it occured on and then change it accordialy manually.
Is there a way to do it automatically for me? Any formula to find a date from the roster and change it if any changes do occur?
The end result I am looking for is that the main roster does not change unless the second sheet has data in it. Do I make sense? I have attached a excel sheet. One sheet has the roster for april and second sheet with dates/reason for roster change.
I appreciate if someone can help me.
Bookmarks