Forum Discussion
Adding additional formula to existing document
Hi @link I am trying (and failing) to add another Absence Key Type to this document. I downloaded this document form the range available from Microsoft. You can see from the image different...
Paul_Evans Templates like this are to be used as they come. They are packed with complicated cross-referencing named ranges, named formulas and conditional formats. They are notoriously difficult to customise.
I believe you would be better off by maintaining a list of all employees absence days by whatever type in one single tabular list (Employee, Date, Type) and use Excel's built-in pivot tables to summarise the lot. By employee, by month or by type. Not as fancy and colourful of course, but fully customisable.