Excel VBA Attendance Monthly Report By Customer

[zaki1979]

Dear Experts,

I would like to create a Macro which will create a customized Monthly Attendance Report By Customer

The Report Should be look like as mentioned below:

For Example, Let's Say we have in our database 2 Clients Jack and Jimmy.
we have 3 records of attendance who belongs to Client Jack (Which means there 3 different Employees who attended in different Jack's site) and
4 records of attendance who belongs to Jimmy (Which means there 4 different Employees who attended in his site)

REPORT DESIGN

New Microsoft Excel Worksheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
5	1. JACK
6	N° MAT.	NOMS ET POST NOMS	EQUIPE	SITE	FONCTION	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	PRESTÉ
7	201132	DIEYI VALA	B	CHICAGO 4	GUARDE	P	P	P	P	P	P	P	P	P	M	M	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	28
8	201506	MABIKA MABIKA	B	CHICAGO 4	GUARDE										P	P	E	E	E															5
9	201535	NGANDU KAYEMBE	A	CHICAGO 4	GUARDE	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	28
10
11	2. JIMMY
12	N° MAT.	NOMS ET POST NOMS	EQUIPE	SITE	FONCTION	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	PRESTÉ
13	201133	BWALIA BANZA	A	CHICAGO 10	GUARDE	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	28
14	201134	LOKANGE EYALE	A	CHICAGO 10	GUARDE												P	P													A	P	P	4
15	201136	TSHUZA KADINDA	B	CHICAGO 10	GUARDE	P	P	P																										3
16	201576	MPIA ISESE	B	CHICAGO 10	GUARDE					P	P	P	P	P	P	P	P						P	P	P	P	P	P	P	P	P	P		18
Sheet1

Attendance Databse or Dataset

my project.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1
2	DATABASE																													P	PRESENT
3																														A	ABSENCE
4																														M	MALADE
5																														R	REPOT
6
7	MATRICULE	NOM	ÉQUIPE	FONCTION	CLIENT	SITE	REMARQUES	UNIQUE_ID	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28
8	201101	MIDO MIWUMBU	A	GUARDE	CLIENT 1	SITE A	RAS	201101_8	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P
9	201102	AKANGA ALONDO	A	GUARDE	CLIENT 2	SITE B	RAS	201102_9	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	M	M	M	M	P	P
10	201103	INGANGE EYENGA	B	GUARDE	CLIENT 3	SITE C	RAS	201103_10	P	P	P	P	P	P	P	A	A	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P
11	201101	MIDO MIWUMBU	A	GUARDE	CLIENT 4	SITE D	TRANSFERT #101	201101_11																			P	P	P	A	A	P	P	P	R	P
12	201104	TEST 1	AB	GUARDE	CLIENT 5	SITE E	RAS	201104_12																											P	P
13	201105	TEST 2	A	GUARDE	CLIENT 1	SITE A	RAS	201105_13									P											P
14	201106	TEST 3	A	GUARDE	CLIENT 7	SITE F	RAS	201106_14					P	P	P
15	201107	TEST 4	A	GUARDE	CLIENT 8	SITE G	RAS	201107_15	P	P	P	A	A	A	P	P															P					P
16	201107	TEST 4	A	GUARDE	CLIENT 2	SITE B	RAS	201107_16									R	P	P	R	A	A	A	P	A
17	201132	DIEYI VALA	B	GUARDE	JACK	CHICAGO 4	RAS	201132_17	P	P	P	P	P	P	P	P	P	M	M	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P
18	201506	MABIKA MABIKA	B	GUARDE	JACK	CHICAGO 4	RAS	201506_18										P	P	E	E	E
19	201535	NGANDU KAYEMBE	A	GUARDE	JACK	CHICAGO 4	RAS	201535_19	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P
20	201133	BWALIA BANZA	A	GUARDE	JIMMY	CHICAGO 10	RAS	201133_20	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P
21	201134	LOKANGE EYALE	A	GUARDE	JIMMY	CHICAGO 10	TRANSFER TO ANOTHER SITE	201134_21												P	P													A	P	P
22	201136	TSHUZA KADINDA	B	GUARDE	JIMMY	CHICAGO 10	TRANSFER TO ANOTHER SITE	201136_22	P	P	P
23	201576	MPIA ISESE	B	GUARDE	JIMMY	CHICAGO 10	TRANSFER TO ANOTHER SITE	201576_23					P	P	P	P	P	P	P	P						P	P	P	P	P	P	P	P	P	P
MASTER DATA

Cell Formulas
Range	Formula
H8:H23	H8	=A8&"_"&ROW()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I8:AJ30	Cell Value	="R"	text	NO
I8:AJ30	Cell Value	="M"	text	NO
I8:AJ30	Cell Value	="A"	text	NO
I8:AJ30	Cell Value	="P"	text	NO