I am using an excel sheet to produce short term construction
programmes. it has the activities duration and start and finish dates
to the left, and cells which are dated mon, tues, wed etc to the
right. I have formulas to colour up the cells to match the dates - so
I have a bar chart. I learnt how to do this by trial and error.

Somebody now wants me to produce the same level of information in a
list ie:

Monday 12.03.12
3No. Fitters New Pipework to Boiler Room
3No. Electricians making connections to Boiler Room
Tuesday 13.03.12
3No. Fitters New Pipework to Boiler Room
3No. Electricians making connections to Boiler Room
1No. Painter painting walls in Boiler Room
Wednesday 14.03.12
3No. Electricians making connections to Boiler Room
1No. Painter painting walls in Boiler Room


And so on. This would be for two weeks worth of work

All the information is available, but I do not know how to select and
paste tpo another tab. I no nothing about programming in excel so
please explain everything

Regards

Andrew