generate weekly report

[new_to_excelvba]

can someone help to generate weekly summary per this file?

raw data entries:

Date	Status1	Status2	Status3	Status4	Week
02 April 2019	Approved	Approved	Approved	Approved	14
03 April 2019	Reject				14
08 April 2019	Approved	Reject			15
08 April 2019	Approved	Approved	Reject		15
09 April 2019	Review pending			15
09 April 2019	Approved	Review pending		15
09 April 2019	Approved	Approved	Approved	Reject	15
09 April 2019	Approved	Approved	Review Pending	15
09 April 2019	Approved	Review pending		15
20 April 2019	Approved	Approved	Approved	Approved	16
20 April 2019	Approved	Approved	Approved	Review Pending	16
20 April 2019	Approved	Reject			16

<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>

required summary format

Summary				<tbody> </tbody>
Week	Status	Status1	Status2	Status3	Status4
Week14	Approved	1	1	1	1
Week14	Reject	1	0	0	0
Week14	Review Pending	0	0	0	0
Week15	Approved	5	2	1	0
Week15	Reject	0	0	0	1
Week15	Review Pending	1	2	0	0
Week16	Approved	3	2	2	1
Week16	Reject	0	1	0	0
Week16	Review Pending	0	0	0	1

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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))