Hi thank you for your response. Unfortunately I cannot I can only use excel at my place of work and it is a closed network with no way of removing or transferring a file. Basically the link I post already shows the exact table I have but you can only put in 1 event per day I am using it as an annual leave tracker so will need to be able to put two events or two people on at the same time