Excel - how to copy the last record in "a" of each user and paste it to "b"

[ramielm]

I need your help on how to copy every last record of each user (highlighted) in column "A" and paste it to adjacent column "B" using macro or VB. Users transaction are separated with blank spaces.

[TABLE="width: 500"]
<tbody>[TR]
[TD]

<colgroup><col width="138"></colgroup><tbody>
[TD="class: xl63, width: 138"]Date Time[/TD]

</tbody>

[/TD]
[TD]

<colgroup><col width="138"></colgroup><tbody>
[TD="class: xl65, width: 138"]Date Time2[/TD]

</tbody>

[/TD]
[TD]

<colgroup><col width="138"></colgroup><tbody>
[TD="class: xl65, width: 138"]User[/TD]

</tbody>

[/TD]
[TD]

<colgroup><col width="138"></colgroup><tbody>
[TD="class: xl65, width: 138"]Transaction #[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:34
[/TD]
[TD]2017-10-03 09:34
[/TD]
[TD]CWA
[/TD]
[TD]9371431935
[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:50
[/TD]
[TD]

<colgroup><col width="138"></colgroup><tbody>
[TD="class: xl66, width: 138"]2017-10-03 09:59[/TD]

</tbody>

[/TD]
[TD]CWA
[/TD]
[TD]9371431942
[/TD]
[/TR]
[TR]
[TD]2017-10-03 14:59
[/TD]
[TD][/TD]
[TD]CWA
[/TD]
[TD]9371431999
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2017-10-03 09:03
[/TD]
[TD]2017-10-03 09:05
[/TD]
[TD]CMM
[/TD]
[TD]9371431954
[/TD]
[/TR]
[TR]
[TD]2017-10-03 09:08
[/TD]
[TD]2017-10-03 09:31
[/TD]
[TD]CMM
[/TD]
[TD]9371431962
[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="138"></colgroup><tbody>
[TD="class: xl66, width: 138"]2017-10-03 10:24[/TD]

</tbody>

[/TD]
[TD]2017-10-03 11:53
[/TD]
[TD]CMM
[/TD]
[TD]9371431996
[/TD]
[/TR]
[TR]
[TD]2017-10-03 13:08
[/TD]
[TD][/TD]
[TD]CMM
[/TD]
[TD]9371432096
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Macropod]

Cross-posted at: https://chandoo.org/forum/threads/how-to-copy-last-record-in-a-and-paste-it-in-b.36597/
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html