On Mar 23, 12:59*am, Vacuum Sealed wrote:
On 23/03/2012 3:36 AM, Andrew Owenson wrote:



On Mar 21, 10:32 pm, Dan *wrote:
If it is a one-time event, it seems you could copy, go to a new sheet,
paste special and select the "transpose" choice.

Dan

this would have to be done once a week, but transposing the
information does not work as for instance act 1 New Pipework to
boilers is carried out on a monday and a tuesday, On the programme
this is represented by one description with two cells (mon Tues)
coloured in.

The programme looks like

cell 1 Cell 2 * * * * * * * * * * * * * * * * * * * * * * Cell
3 * * * * * * *Cell4 * * * * * * * * * * * *Cell 5 * * * * * * *Cell
6 * * * * Cell 7 Cell8 Cell 9 Cell 10 *Cell 11
Id * * * *Description * * * * * * * * * * * * * * * * *No. of men
Duration in days * *Start * * * * * * * *Finish * * * * *Mon * *Tues
Wed * *Thurs * Frid

12 * * * 13 * * * *14 * * * *15 * * * *16

01 * * New Pipework to bioler room * * 4No.
2d * * * * * * * * * * * * * * 12/03/12 * * 13/03/12 * * fill
fill
02 * * Connections
3No. * * * * * * * * 1d * * * * * * * * * * * * * * 13/03/12
13/03/12 * * * * * * * * *fill

What I need as well is

Monday 12th
4No. New Pipework to Boiler Room

Tues 13th
4No. New Pipework in Boiler Room
3No. Connections

Hopefully this is clearer

Regards

Andrew

Sound more like you need a Gantt Chart.

http://office.microsoft.com/en-us/te...-chart-TC03000...

HTH
Mick.- Hide quoted text -

- Show quoted text -

We do use software to produce gantt charts for the main programme, but
people on site are more comfortable using excel to produce a two week
gantt chart.