generate weekly report

[new_to_excelvba]

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]

 

[AlanY]

try this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date	Status1	Status2	Status3	Status4	Week		Week	Status	Status1	Status2	Status3	Status4
2	02-Apr-19	Approved	Approved	Approved	Approved	14		Week14	Approved	1	1	1	1
3	03-Apr-19	Reject				14		Week14	Reject	1	0	0	0
4	08-Apr-19	Approved	Reject			15		Week14	Review Pending	0	0	0	0
5	08-Apr-19	Approved	Approved	Reject		15		Week15	Approved	6	3	1	0
6	09-Apr-19	Review pending				15		Week15	Reject	0	1	1	1
7	09-Apr-19	Approved	Review pending			15		Week15	Review Pending	1	2	1	0
8	09-Apr-19	Approved	Approved	Approved	Reject	15		Week16	Approved	3	2	2	1
9	09-Apr-19	Approved	Approved	Review Pending		15		Week16	Reject	0	1	0	0
10	09-Apr-19	Approved	Review pending			15		Week16	Review Pending	0	0	0	1
11	20-Apr-19	Approved	Approved	Approved	Approved	16
12	20-Apr-19	Approved	Approved	Approved	Review Pending	16
13	20-Apr-19	Approved	Reject			16
14
Sheet5

Cell Formulas
Range	Formula
J2	=COUNTIFS(INDEX($B$2:$E$13,,MATCH(J$1,$J$1:$M$1,0)),$I2,$F$2:$F$13,RIGHT($H2,2))