I have an worksheet labeled input, This contains a series of data that I need created into a calander view, labeled 'Free Time'
This represents bookings for our contractors to our customers.
* the pivot table needs to be able to select all the data in the input sheet.
* When the pivit table is created, it only shows the dates in the row labels if they exist in the input sheet, i need to have all dates show,so we can easily see if we have free dates.
* I manually copy and paste the infromation from the pivot table into the Calander view. I would like this automated as well. This design of this is simple ( You can change if you like, if you have a better or easier one.) All it does is break down into months down the screen so you dont have to scroll all the way across.
* If also hilights in green if we have free time on that date ( via a conditional formatting )