Move value form last date to last date between two sheets and insert total row

[Mussala]

Hello
I want move value in last cell for last duplicated date for column F from ENTER sheet to SH sheet in last cell for last duplicated date in column F .
in enter sheet will change the date so will move value based on the same date between two sheets and insert TOTAL row after last cell for last duplicated date and sum TOTAL for each date by last row to sum the whole dates .
so I put the formula how should be and the result how show in SH sheet . the macro should not insert TOTAL row repeatedly when every time run the macro , with considering when there is value in enter sheet should move to sh sheet even if has already inserted the row for that date .

DATE.xlsm
	A	B	C	D	E	F
1	DATE	ITEM	IMPORT	EXPORT	BALANCE	REAL
2	15/06/2023	ITFG-001	2,000.00		2,000.00
3	15/06/2023	ITFG-002	2,200.00	1,000.00	1,200.00
4	15/06/2023	ITFG-003	2,400.00	2,000.00	400.00
5	15/06/2023	ITFG-004	2,600.00		2,600.00
6	16/06/2023	ITFG-005	2,800.00		2,800.00
7	16/06/2023	ITFG-006	3,000.00	1,200.00	1,800.00
8	16/06/2023	ITFG-007	3,200.00	200.00	3,000.00
9	16/06/2023	ITFG-008	3,400.00	200.00	3,200.00
10	17/06/2023	ITFG-009	3,600.00	500.00	3,100.00
11	18/06/2023	ITFG-010	3,800.00		3,800.00
12	19/06/2023	ITFG-011	4,000.00	500.00	3,500.00
13	19/06/2023	ITFG-012	4,200.00	600.00	3,600.00
14	19/06/2023	ITFG-013	4,400.00	700.00	3,700.00
15	19/06/2023	ITFG-014	4,600.00		4,600.00
16	19/06/2023	ITFG-015	4,800.00		4,800.00
17	19/06/2023	ITFG-016	5,000.00	100.00	4,900.00
18	19/06/2023	ITFG-017	5,200.00		5,200.00
19	TOTAL		61,200.00	7,000.00	54,200.00
sh

Cell Formulas
Range	Formula
E2:E19	E2	=C2-D2
C19:D19	C19	=SUM(C2:C18)

DATE.xlsm
	A	B	C	D	E	F
1	DATE	ITEM	IMPORT	EXPORT	BALANCE	REAL
2	15/06/2023	ITFG-001	2,000.00		2,000.00
3	15/06/2023	ITFG-002	2,200.00	1,000.00	1,200.00
4	15/06/2023	ITFG-003	2,400.00	2,000.00	400.00
5	15/06/2023	ITFG-004	2,600.00		2,600.00	2,000.00
6	TOTAL		9,200.00	3,000.00	6,200.00
enter

Cell Formulas
Range	Formula
E2:E6	E2	=C2-D2
C6:D6	C6	=SUM(C2:C5)

should be in SH sheet

DATE.xlsm
	A	B	C	D	E	F
1	DATE	ITEM	IMPORT	EXPORT	BALANCE	REAL
2	15/06/2023	ITFG-001	2,000.00		2,000.00
3	15/06/2023	ITFG-002	2,200.00	1,000.00	1,200.00
4	15/06/2023	ITFG-003	2,400.00	2,000.00	400.00
5	15/06/2023	ITFG-004	2,600.00		2,600.00	2,000.00
6	TOTAL		9,200.00	3,000.00	6,200.00
7	16/06/2023	ITFG-005	2,800.00		2,800.00
8	16/06/2023	ITFG-006	3,000.00	1,200.00	1,800.00
9	16/06/2023	ITFG-007	3,200.00	200.00	3,000.00
10	16/06/2023	ITFG-008	3,400.00	200.00	3,200.00
11	TOTAL		12,400.00	1,600.00	10,800.00
12	17/06/2023	ITFG-009	3,600.00	500.00	3,100.00
13	TOTAL		3,600.00	500.00	3,100.00
14	18/06/2023	ITFG-010	3,800.00		3,800.00
15	TOTAL		3,800.00	0.00	3,800.00
16	19/06/2023	ITFG-011	4,000.00	500.00	3,500.00
17	19/06/2023	ITFG-012	4,200.00	600.00	3,600.00
18	19/06/2023	ITFG-013	4,400.00	700.00	3,700.00
19	19/06/2023	ITFG-014	4,600.00		4,600.00
20	19/06/2023	ITFG-015	4,800.00		4,800.00
21	19/06/2023	ITFG-016	5,000.00	100.00	4,900.00
22	19/06/2023	ITFG-017	5,200.00		5,200.00
23	TOTAL		32,200.00	1,900.00	30,300.00
24	TOTAL		61,200.00	7,000.00	54,200.00
result

Cell Formulas
Range	Formula
C11:D11,C6:D6	C6	=SUM(C2:C5)
C15:D15,C13:D13	C13	=SUM(C12)
E2:E24	E2	=C2-D2
C23:D23	C23	=SUM(C16:C22)
C24:D24	C24	=C6+C11+C13+C15+C23

also posted here
https://www.excelforum.com/excel-pr...ue-form-last-date-to-last-date-between-two-sh
thanks

 

[Mussala]

need help after tis period, please?