match duplicates names to sum & subtract for each other

[Omran Y]

Hello
I want creating report in OUTPUT sheet .
it should populate names and sum amounts in DEBIT column and CREDIT column for each duplicates names
and insert TOTAL row to sum whole columns DEBIT,CREDIT . every time I will add new data in ALL sheet so should clear data before brings in OUPUT sheet
the names will be in last location in item .
the data could be 5000 rows

OMRAN.xlsm
	A	B	C	D
1	DATE	DESCRIBE	DEBIT	CREDIT
2	01/01/2023	SALES INVOICE AT300 - OMRAN OMAR	3,000.00
3	02/01/2023	SALES INVOICE AT301 - OMAR ALI	6,000.00
4	03/01/2023	SALES INVOICE AT302 - ALI OMARN	10,000.00
5	04/01/2023	PAID OMRAN OMAR		1,000.00
6	05/01/2023	PAID ALI OMARN		2,000.00
7	06/01/2023	SALES INVOICE AT303 - OMRAN OMAR	3,000.00
8	07/01/2023	SALES INVOICE AT304 - ALI OMARN	50,000.00
9	08/01/2023	PAID OMRAN OMAR		1,200.00
10	09/01/2023	PAID OMRAN OMAR		200.00
all

before

OMRAN.xlsm
	A	B	C	D	E
1	ITEM	NAME	DEBIT	CREDIT	BALANCE
2
3
4
5
OUTPUT

result

OMRAN.xlsm
	A	B	C	D	E
1	ITEM	NAME	DEBIT	CREDIT	BALANCE
2	1	OMRAN OMAR	6,000.00	2,400.00	3,600.00
3	2	OMAR ALI	6,000.00	0.00	6,000.00
4	3	ALI OMARN	60,000.00	2000	58,000.00
5	TOTAL		72,000.00	4,400.00	67,600.00
OUTPUT

Cell Formulas
Range	Formula
E2:E5	E2	=C2-D2
C5:D5	C5	=SUM(C2:C4)

 

[Georgiboy]

You're welcome, thanks for the feedback.