Hello All,
I am trying to merge four different excel spreadsheets so when an employee updates that sheet it updates a master list of employees off for the day. I have use paste link to add the four sheets on to one in my master list and now want to show all those names on the calendar when they are off. I have been using Pete_UK updated calendar and have been trying to make an adjustment to add days off for an employees. Basically have the employees name in column C and then 18 columns after it with their picks but I can't figure out how to adjust the formula to do that. Any help would be appreciated.
The sheets look like this
23-May 25-May 27-May 12-Jul 14-Jul 17-Jul 2-May 4-May 6-May 28-Sep 19-Apr 21-Apr 15-Jun 09-Apr 11-Apr 13-Apr 15-Apr 19-Mar 30-Sep
Bookmarks