Summarise cells - row by row

[leeksleeks]

Hi,

I need to be able to summarise the table below to show who was doing what hour by hour so that this can be used in a database. Essentially I need to extract an hour by hour view from the large table below to just return this:

08:00	name.1	SALES 2
08:00	name.4	TRAINING
08:00	name.6	SALES 1
08:30	name.1	SALES 2

<tbody>
</tbody>

This is the table that I want the data to be summarised from. Is there some VBA code that can extract the time, name and task from each of the lines where there is data on it? So if there is a task assigned, return the time of that task and the name at the top of the column.

name.1 name.2 name.3 name.4 name.5 name.6 name.7 name.8 08:00 SALES 2 TRAINING SALES 1 08:30 SALES 2 TRAINING SALES 1 09:00 SALES 2 TRAINING SALES 1 TRAINING 09:30 SALES 2 TRAINING SALES 1 TRAINING 10:00 SALES 2 SALES 1 TRAINING SALES 4 SALES 5 SALES 6 10:30 SALES 2 SALES 1 TRAINING SALES 4 SALES 5 SALES 6 11:00 SALES 2 SALES 1 TRAINING SALES 4 SALES 5 TRAINING 11:30 SALES 2 SALES 1 TRAINING SALES 4 SALES 5 TRAINING 12:00 SALES 2 SALES 1 TRAINING SALES 4 SALES 4 TRAINING 12:30 SALES 2 SALES 1 TRAINING OOF SALES 4 TRAINING 13:00 SALES 2 SALES 2 SALES 1 TRAINING SALES 1 OOF SALES 4 TRAINING 13:30 SALES 4 SALES 2 SALES 1 TRAINING SALES 1 OOF SALES 4 TRAINING 14:00 SALES 4 MEETING SALES 1 TRAINING MEETING SALES 2 SALES 2 TRAINING 14:30 SALES 4 MEETING SALES 1 TRAINING MEETING SALES 2 SALES 2 TRAINING 15:00 SALES 4 MEETING SALES 1 TRAINING MEETING SALES 2 SALES 2 TRAINING 15:30 SALES 4 MEETING SALES 1 TRAINING MEETING SALES 2 SALES 2 TRAINING 16:00 SALES 4 MEETING SALES 1 TRAINING MEETING SALES 2 SALES 2 TRAINING 16:30 SALES 4 SALES 1 TRAINING SALES 2 TRAINING 17:00 SALES 4 SALES 1 TRAINING SALES 2 TRAINING 17:30 SALES 4 SALES 1 TRAINING SALES 2 18:00 SALES 4 SALES 1 TRAINING SALES 2 18:30 SALES 2 SALES 1 19:00 SALES 2 SALES 1 19:30 SALES 2 SALES 1 20:00 SALES 2 SALES 1 20:30 SALES 2 SALES 1 21:00 SALES 2 SALES 1 21:30 <colgroup><col span="3"><col><col span="2"><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[leeksleeks]

I have tried both yours and Peter_SSs and they both work perfectly. Thank you for your work here. It has saved me hours of banging my head against my desk!

 

[Peter_SSs]

I have tried both yours and Peter_SSs and they both work perfectly.

Good news - you have choice! Thanks for letting us know.

 

[sandy666]

You are welcome

Have a nice day