Käynnissä

Excel Script to create pivot table in calander view.

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 )

Taidot: Excel

Näytä lisää: script create pivot table, pivot design, conditional design, time table, pivot table excel, hilights, excel pivot, excel pivot table, excel formatting, create excel worksheet, excel sheet formatting, excel contains, simple script excel, copy screen data excel, series script, excel input sheet, table exist, time series script, excel data sheet design, table create script, simple design excel, automated time table, create excel table, excel script copy sheet, excel conditional formatting

About the Employer:
( 6 reviews ) Sutherland, Australia

Projektin tunnus: #4274179

Myönnetty käyttäjälle:

Gooroo

Hired by the Employer

30 $ USD 3 päivässä
(12 arvostelua)
3.8