Hi guys just joined up, have been putting together a rostering system at my place of work and have hit a snag. I used this guide http://www.get-digital-help.com/2013/09/05/pivot-table-calendar/?replytocom=74548#respond



To create a pivot table, now having never used or experienced a pivot table I am at a loss. The table is beautiful exactly what I want except I don't know how to add multiple "events" or in my case staff to the same day for my purposes. Seems its only designed for one. Does anyone know of a work around? The person who wrote the guide hasn't responded

Hi and welcome
could you please post a sample sheet ( no pics please) showing some data and expected results( Click Go advanced - Manage attachments)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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