One feature that has been added to the days based Holiday Scheduler is the refreshing of the formulae in each cell of “Individual Calendars”.
When you go to “Individual Calendars” a piece of code will copy the formulae from a hidden sheet and replace the formulae in the “Individual Calendars” page. If there have been any changes you will be asked “Do you wish to replace the contents of the destination cells?” You should answer yes.
This automatically alleviates the problem of people erroneously entering data into this sheet.