to do list in calender

[dss28]

I have designed a calender with a to do list in which each row is assigned for to do list serial no. and columns have dates.

when a cell is clicked it opens a userform1 with 4-5 textboxes/ comboboxes, which now at present is filled manually by selecting the particular row and date column. The data so entered is saved on a "CalenderData" sheet.

I want to automate the process now and data transfer is to be linked to some other userform2 which will capture the details required for "CalenderData" sheet.
the data in "CalenderData" sheet has following column headings.

There are about 24 rows so that the user can fill upto 30 todo items on a particular date (in column).

iRow​

Date

To Do No.

Name

To do Title

Status

Remarks

The to Do No. column corresponds to the row number on a particular date
While transferring the data from userform2 to "CalenderData" sheet, it should automatically identify the next serial no. (To DO No.) on a particular date. (eg. filter the Calender data sheet by date and then by ToDONo. column and find the next serial no. ) when a particular entry on a date is to be done.

my data on the "CalenderData" sheet looks like this..

iRow	Date	To Do No.	Name	To do Title	Status	Remarks
1	03-07-2021	1	aaa	aaa1	aaa2	aaa3
2	01-08-2021	1	bbb	bbb1	bbb2	bbb3
3	02-08-2021	1	ccc	ccc1	ccc2	ccc3
4	04-07-2021	1	ddd	ddd1	ddd2	ddd3
5	04-07-2021	2	eee	eee1	eee2	eee3
6	02-08-2021	2	fff	fff1	fff2	fff3
7	04-07-2021	3	ggg	ggg1	ggg2	ggg3
8	04-07-2021	4	hhh	hhh1	hhh2	hhh3
9	01-09-2021	1	iii	iii1	iii2	iii3
10	15-09-2021	1	jjj	jjj1	jjj2	jjj3
11	01-09-2021	2	kkk	kkk1	kkk2	kkk3
12	10-10-2021	1	lll	lll1	lll2	lll3
13	10-10-2021	2	mmm	mmm1	mmm2	mmm3
14	16-09-2021	1	ooo	ooo1	ooo2	ooo3
15	10-10-2021	3	ppp	ppp1	ppp2	ppp3
16	01-11-2021	1	qqq	qqq1	qqq2	qqq3
17	05-11-2021	1	rrr	rrr1	rrr2	rrr3
18	05-11-2021	2	sss	sss1	sss2	sss3
19	10-10-2021	4	ttt	ttt1	ttt2	ttt3
20	10-10-2021	5	uuu	uuu1	uuu2	uuu3

Hence if am entering a new to do job :
1) for say date 16/09/2021, it should assign a next todo number ie 2 in this case as Sr No. 1 is already used.
2 )for say date 05/11/2021, it should assign a next todo number ie 3 in this case as Sr No. 1 and 2 are already used.

so my aim is to capture the next serial number in textbox3 for ToDONo. as soon as textbox2 for Date is filled up by the user in userform2.

my calender looks like this

	04-10-2021	05-10-2021	06-10-2021	07-10-2021	08-10-2021	09-10-2021	10-10-2021	11-10-2021	12-10-2021	13-10-2021	14-10-2021	15-10-2021	16-10-2021	17-10-2021	18-10-2021	19-10-2021
No.	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday
1	aaa
2	bbb
3	ccc
4	ddd
5	eee
6	fff
7	ggg	ggg
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24