L
Legacy 171839
Guest
Hi all,
Pulling the hair I have left out.
I have several rows of data, making up a working day in 5 min increments.
I want to copy and paste the data from the lower rows into the 1st row, to finish with 1 line of data for the day.
If there is an over lap, the data from the lines below should take precedence.
Example of the data I have, and what I want the macro to do are in the 2 tables below.
I hope I have been able to articulate what I am trying to acheive in a way that makes sense.
Any help at all will be greatly received.
Kind regards
<tbody>
</tbody>
<tbody>
</tbody>
Pulling the hair I have left out.
I have several rows of data, making up a working day in 5 min increments.
I want to copy and paste the data from the lower rows into the 1st row, to finish with 1 line of data for the day.
If there is an over lap, the data from the lines below should take precedence.
Example of the data I have, and what I want the macro to do are in the 2 tables below.
I hope I have been able to articulate what I am trying to acheive in a way that makes sense.
Any help at all will be greatly received.
Kind regards
John | John | John | John | John | John | |||||||||
Dave | Dave | Dave | Dave | |||||||||||
Pete | Pete | |||||||||||||
Alex | Alex | Alex | Alex |
<tbody>
</tbody>
John | John | Dave | Dave | Dave | Dave | Pete | Pete | John | Alex | Alex | Alex | Alex | ||
<tbody>
</tbody>