Create Calendar Showing 4 Types of Info

[Invicta9]

I am looking to create a file migration calendar in Excel that will show four types of information: the name of the person doing the transfer, where the file is located, the group to which the file belongs, and the date of the transfer. I have this information in an Excel spreadsheet but not in a calendar format. Rather than redundantly typing each piece of information, I would like the calendar to pull the data from the other worksheet. Would anyone be able to help me with this? Thank you!

 

[RasGhul]

How may people need to be shown on one day?

Would you like to see whole month or current week?

 

[Invicta9]

How may people need to be shown on one day?

Would you like to see whole month or current week?

Whole month. I believe 7 people max.

 

[RasGhul]

Maybe you could change this to suit, there would need to be a row in your data for each type of info you want to see in calendar for that date;

Calendar Sheet_new.xlsm
	A	B	C	D	E	F
1	Date	Client	Mobile	Column2	Status	Payment
2	01/08/21	Client 1			Booking	Card
3	01/08/21	Client 2			Booking	Card
4	01/08/21	Client 3			Booking	Card
5	01/08/21	Client 4			Booking	Card
6	01/08/21	Client 5			Booking	Card
7	01/08/21	Client 6			Booking	Card
8	07/08/21	Client 7			Booking	Card
9	07/08/21	Client 8			Booking	Card
10	07/08/21	Client 9			Booking	Card
11	07/08/21	Client 10			Booking	Card
12	07/08/21	Client 11			Booking	Card
13	07/08/21	Client 12			Booking	Card
14	07/08/21	Client 13			Booking	Card
15	07/08/21	Client 14			Booking	Card
16	07/08/21	Client 15			Booking	Card
17	16/08/21	Client 16			Booking	Card
18	16/08/21	Client 17			Booking	Card
19	16/08/21	Client 18			Booking	Card
20	16/08/21	Client 19			Booking	Card
21	16/08/21	Client 20			Booking	Card
22	16/08/21	Client 21			Booking	Card
Appointments

Calendar Sheet_new.xlsm
	A	B	C	D	E	F	G	H	I	J
1									1st of Month	1/08/2021
2	Today's Date	27/08/2021				Aug 2021			Weekday	1
3									Month 1	8
4									Month 2	9
5	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday		EOM Month 2	30/09/2021
6	1/08/2021	2/08/2021	3/08/2021	4/08/2021	5/08/2021	6/08/2021	7/08/2021
7	Client 1						Client 7
8	Client 2						Client 8
9	Client 3						Client 9
10	Client 4						Client 10
11	Client 5						Client 11
12	Client 6						Client 12
13							Client 13
14							Client 14
15							Client 15
16
17	8/08/2021	9/08/2021	10/08/2021	11/08/2021	12/08/2021	13/08/2021	14/08/2021
18
19
20
21
22
23
24
25
26
27
Calendar

Cell Formulas
Range	Formula
B2	B2	=TODAY()
F2	F2	=G6
A5:G5	B5	=B6
A6:G6	B6	=COLUMNS($A$6:B6)-$J$2+$J$1
J1	J1	=EOMONTH($B$2,-1)+1
J2	J2	=WEEKDAY(J1,1)
J3	J3	=MONTH(J1)
J4	J4	=MONTH(EOMONTH($J$1,0)+1)
J5	J5	=EOMONTH(J1,1)
A7	A7	=IF(MONTH(A$6)<>$J$3,"",IF(ROWS(A$7:A7)>COUNTIFS(Salesdata[Date],A$6,Salesdata[Status],"Booking"),"",INDEX(Salesdata[Client]&" "&Salesdata[Column2],SMALL(IF(Salesdata[Date]&Salesdata[Status]=A$6&"Booking",ROW(Salesdata[Date])-ROW(Salesdata[#Headers])),ROWS(A$7:A7)))))