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 key types. Vacation, Personal, Sick, Custom 1 & 2. I'm trying to add more of these keys but i can't seem to be able to update the table/formula so that the colour and letter updates the table below.
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.
