Multi-Variable table search to fill horizontal calendar from data table

[NatDeroxL7]

Trying to figure out how to get a horizontal daily calendar to fill with information from an open ended table. Basically, I want each employee to simply enter data into the table at the bottom, and the calender will built itself from colum C to the right for 2 years worth of dates.

Test Sheet .xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1			1-Oct-23	2-Oct-23	3-Oct-23	4-Oct-23	5-Oct-23	6-Oct-23	7-Oct-23	8-Oct-23	9-Oct-23	10-Oct-23	11-Oct-23	12-Oct-23	13-Oct-23	14-Oct-23	15-Oct-23	16-Oct-23
2	A		Conference Start			Conference End					New Computers Start
3	Employee hire date	Cost	5400								3400
4	Position	Fund Source	Store A								Store C
5		Activity Type	Travel								Purchase
6	B						Sales Trip Start					Sales Trip End
7	Employee hire date	Cost					1200
8	Position	Fund Source					Store A
9		Activity Type					Travel
10	C		Install Storage Start									Install Storage End
11	Employee hire date	Cost	3400
12	Position	Fund Source	Store B
13		Activity Type	Facility Improvement
14	D								Advertising Start									Advertising End
15	Employee hire date	Cost							500
16	Position	Fund Source							Store B
17		Activity Type							Purchase
18
19
20
21	Name	Start Date	End Date	Cost	Fund Source	Activity Name	Activity Type
22	A	1-Oct-23	4-Oct-23	5400	Store A	Conference	Travel
23	B	5-Oct-23	10-Oct-23	1200	Store A	Sales Trip	Travel
24	C	1-Oct-23	10-Oct-23	3400	Store B	Install Storage	Facility Improvement
25	A	9-Oct-23	9-Oct-23	1200	Store C	New Computers	Purchase
26	D	7-Oct-23	16-Oct-23	500	Store B	Advertising	Purchase
27	List continutes indefinitely…....
Sheet1

Cell Formulas
Range	Formula
D1:R1	D1	=C1+1

 

[NatDeroxL7]

Also to note, the table can't need to be in any particular order, I need the employees to be able to just add things to it on the next line down at any time with no sorting etc.

 

[NatDeroxL7]

Correction to the original post / goal.

Trying to figure out how to get a horizontal daily calendar to fill with information from an open ended table. Basically, I want each employee to simply enter data into the table at the bottom, and the calendar will built itself from column C to the right for 2 years worth of dates. I also need it to work with the table at the bottom being in any order - I need the employees to be able to enter a new line at any time at the bottom without regard for it the dates or names or anything else is in a particular order. I specifically want the activity name to only show in the start and end dates boxes, but I want the activity type to fill every dates between the start and end dates, inclusive of the start and end dates. (So I can conditionally format with colors later on) Would be ideal if it automatically append the words "Start" and "End" to calendar entries as shown based on the start/end dates, but I could live without that.

Test Sheet (1).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1			1-Oct-23	2-Oct-23	3-Oct-23	4-Oct-23	5-Oct-23	6-Oct-23	7-Oct-23	8-Oct-23	9-Oct-23	10-Oct-23	11-Oct-23	12-Oct-23	13-Oct-23	14-Oct-23	15-Oct-23	16-Oct-23
2	A		Conference Start			Conference End					New Computers Start
3	Employee hire date	Cost	5400								3400
4	Position	Fund Source	Store A								Store C
5		Activity Type	Travel	Travel	Travel	Travel					Purchase
6	B						Sales Trip Start					Sales Trip End
7	Employee hire date	Cost					1200
8	Position	Fund Source					Store A
9		Activity Type					Travel	Travel	Travel	Travel	Travel	Travel
10	C		Install Storage Start									Install Storage End
11	Employee hire date	Cost	3400
12	Position	Fund Source	Store B
13		Activity Type	Facility Improvement	Facility Improvement	Facility Improvement	Facility Improvement	Facility Improvement	Facility Improvement	Facility Improvement	Facility Improvement	Facility Improvement	Facility Improvement
14	D								Advertising Start									Advertising End
15	Employee hire date	Cost							500
16	Position	Fund Source							Store B
17		Activity Type							Purchase	Purchase	Purchase	Purchase	Purchase	Purchase	Purchase	Purchase	Purchase	Purchase
18
19
20
21	Name	Start Date	End Date	Cost	Fund Source	Activity Name	Activity Type
22	A	1-Oct-23	4-Oct-23	5400	Store A	Conference	Travel
23	B	5-Oct-23	10-Oct-23	1200	Store A	Sales Trip	Travel
24	C	1-Oct-23	10-Oct-23	3400	Store B	Install Storage	Facility Improvement
25	A	9-Oct-23	9-Oct-23	1200	Store C	New Computers	Purchase
26	D	7-Oct-23	16-Oct-23	500	Store B	Advertising	Purchase
27	List continutes indefinitely…....
Sheet1

Cell Formulas
Range	Formula
D1:R1	D1	=C1+1