new_to_excelvba
New Member
- Joined
- Apr 15, 2019
- Messages
- 1
can someone help to generate weekly summary per this file?
raw data entries:
[TABLE="width: 417"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Status1[/TD]
[TD]Status2[/TD]
[TD]Status3[/TD]
[TD]Status4[/TD]
[TD]Week[/TD]
[/TR]
[TR]
[TD="align: right"]02 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]03 April 2019[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]08 April 2019[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]08 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD="colspan: 2"]Review pending[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD="colspan: 2"]Review pending[/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD="colspan: 2"]Review Pending[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD="colspan: 2"]Review pending[/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]20 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]20 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]20 April 2019[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]
required summary format
[TABLE="width: 423"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Summary[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: left"]
<tbody>
</tbody>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Week[/TD]
[TD]Status[/TD]
[TD]Status1[/TD]
[TD]Status2[/TD]
[TD]Status3[/TD]
[TD]Status4[/TD]
[/TR]
[TR]
[TD]Week14[/TD]
[TD]Approved[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Week14[/TD]
[TD]Reject[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week14[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week15[/TD]
[TD]Approved[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week15[/TD]
[TD]Reject[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Week15[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week16[/TD]
[TD]Approved[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Week16[/TD]
[TD]Reject[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week16[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
raw data entries:
[TABLE="width: 417"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Status1[/TD]
[TD]Status2[/TD]
[TD]Status3[/TD]
[TD]Status4[/TD]
[TD]Week[/TD]
[/TR]
[TR]
[TD="align: right"]02 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]03 April 2019[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]08 April 2019[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]08 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD="colspan: 2"]Review pending[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD="colspan: 2"]Review pending[/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD="colspan: 2"]Review Pending[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]09 April 2019[/TD]
[TD]Approved[/TD]
[TD="colspan: 2"]Review pending[/TD]
[TD] [/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]20 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]20 April 2019[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Approved[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]20 April 2019[/TD]
[TD]Approved[/TD]
[TD]Reject[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]
required summary format
[TABLE="width: 423"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Summary[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: left"]
![clip_image001.png](/board/proxy.php?image=http%3A%2F%2Ffile%3A%2F%2F%2FC%3A%2FUsers%2FRMOORJ%7E1%2FAppData%2FLocal%2FTemp%2Fmsohtmlclip1%2F01%2Fclip_image001.png&hash=2bf193c40ffa678edd3fa7531a86e164)
<tbody>
</tbody>
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Week[/TD]
[TD]Status[/TD]
[TD]Status1[/TD]
[TD]Status2[/TD]
[TD]Status3[/TD]
[TD]Status4[/TD]
[/TR]
[TR]
[TD]Week14[/TD]
[TD]Approved[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Week14[/TD]
[TD]Reject[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week14[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week15[/TD]
[TD]Approved[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week15[/TD]
[TD]Reject[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Week15[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week16[/TD]
[TD]Approved[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Week16[/TD]
[TD]Reject[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Week16[/TD]
[TD]Review Pending[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]