Trying to make/have a PTO calendar that tracks 4 different work centers with different employees

[Udub2180]

So I have got the calendar set up that I can change the months successfully to the end of the year and will populate the different employees in the work centers, I'm thinking I'll have to do VBA again to hide calendars for different work centers to be able to track everything correctly? Any help would be appreciated. I ultimately want to be able to put this on a ONEdrive to share it across my work

Excel Leave Tracker.xlsm
	A
3	Work Center 1
Leave Tracker

Cells with Data Validation
Cell	Allow	Criteria
A3	List	=Sheet3!$J$1:$M$1

Excel Leave Tracker.xlsm
	K
16
Sheet3

 

[Udub2180]

Excel Leave Tracker.xlsm
	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
1
2	Work Center
3	Work Center 1
4	2025
5		Quarter 1
6	Week	1	1	1	1	2	2	2	2	2	2	2	3	3	3	3	3	3	3	4	4	4	4	4	4	4	5	5	5	5	5	5
7	Day	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri
8	Name	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	29	30	31
9	J
10	F
11	S
12	V
13	H
14	S
15	T
16	W
17	B
18	N
Leave Tracker

Cell Formulas
Range	Formula
B5	B5	="Quarter "&ROUNDUP(MONTH(Sheet3!$G$2)/3,0)
B6:AF6	B6	=IF(B$8="","",WEEKNUM(DATE($A$4,XLOOKUP($A$1,Sheet3!$B$1:$B$12,Sheet3!$B$1:$B$12,""),COLUMNS($A$7:A7)),1))
B7:AF7	B7	=IF(B$8="","",VLOOKUP(WEEKDAY(DATE($A$4,$A$1,B8),2),Sheet3!$D$1:$E$7,2,0))
B8:AF8	B8	=IF(AND((COLUMN()-1)>31*($A$1-1),MONTH(DATE($A$4+INT(($A$1+1)/12),IF((INT((COLUMN()-1)/31.001)+1)>12,(INT((COLUMN()-1)/31.001)+1-12),INT((COLUMN()-1)/31.001)+1),ROUNDUP(MOD(COLUMN()-1,31.001),0)))=ROUNDUP(MOD(1+$A$1-1,12.01),0)),ROUNDUP(MOD(COLUMN()-1,31.001),0),"")
A9:A22	A9	=IF((XLOOKUP(A3,Sheet3!J1:M1,Sheet3!J2:M15," ",0)=0),"",XLOOKUP(A3,Sheet3!J1:M1,Sheet3!J2:M15," ",0))
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B7:NI7	Expression	=IF(VLOOKUP(B7,$NW$22:$NX$28,2,0)="No",TRUE,FALSE)	text	NO
B9:NI28	Expression	=AND(B$8<>"",VLOOKUP(B$7,$NW$22:$NX$28,2,0)<>"Yes")	text	YES
B9:NI28	Expression	=ISNUMBER(MATCH(DATE($A$4,$A$1,B$8),HolidayListNamedRange,0))	text	YES
B9:NI28	Expression	=OR(B9=$NX$9,B9=$NX$10,B9=$NX$11,B9=$NX$12,B9=$NX$13,B9=$NX$14,B9=$NX$15,B9=$NX$16)	text	NO
B9:NI28	Expression	=OR(B9=$NX$17,B9=$NX$18)	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B9:AF18	Custom	=B$7<>""
A3	List	=Sheet3!$J$1:$M$1

Excel Leave Tracker.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	January	1		1	Mon		January 2025			Work Center 1	Work Center 2	Workcenter 3a	Workcenter 3b
2	February	2		2	Tue		January 2025			J	U	W	L
3	March	3		3	Wed					F	J	S	M
4	April	4		4	Thu					S	B	X	N
5	May	5		5	Fri					V	K	C	K
6	June	6		6	Sat					H	O	D	I
7	July	7		7	Sun					S	T	E	U
8	August	8								T	F	R	J
9	September	9								W	B	F	B
10	October	10								B	C	V	H
11	November	11								N	S	B	T
12	December	12									B	G	D
13											W	T	S
14											H	Y
15											Y	H
16
17
18
Sheet3

Cell Formulas
Range	Formula
G1	G1	=INDEX($A$1:$A$12,MATCH('Leave Tracker'!$A$1,Sheet3!$B$1:$B$12,0))&" "&'Leave Tracker'!$A$4
G2	G2	=INDEX($A$1:$A$12,MATCH(MONTH(DATE('Leave Tracker'!$A$4,'Leave Tracker'!$A$1,1)),$B$1:$B$12,0))&" "&YEAR(DATE('Leave Tracker'!$A$4,'Leave Tracker'!$A$1,1))