leeksleeks
Board Regular
- Joined
- Oct 31, 2013
- Messages
- 96
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:
<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.
<tbody>
</tbody>
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.
<colgroup><col span="3"><col><col span="2"><col><col><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>