I have read many posts similar to this but can't get my vba code to work. Please help.
Sample data:
<tbody>
A1
A2
A3
A4
A5
A6A7
</tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
21609
Gold
$10
Person1
1
$10
Raffle1
21609
Gold
$10
Person2
9
$90
Raffle1
21609...