sort & insert TOTAL row and BALANCE column together for duplicates items

[Maklil]

Hi
I want sort data from sheet1 to sheet2 based on column E . the column BALANCE should subtract column F from column G and the row TOTAL shoud summing values in columns F,G with considering also subtract column F from column G for each TOTAL row in column BALANCE and should show hyphen for any cell is empty or contain zero .

Microsoft Excel (2).xlsx
	A	B	C	D	E	F	G
1	DATE	INVOICE NO	MADE	DEL.NO	BRAND	IMPORT	EXPORT
2	1/1/2021	INV1000	CHI	GGOD2	ELEC-1000	200
3	1/2/2021	INV1000	TUR	GGOD3	ELEC-1001	1200
4	1/3/2021	INV1000	IT	GGOD4	ELEC-1002		122
5	1/4/2021	INV1001	VIT	GGOD5	ELEC-1003	1200
6	1/5/2021	INV1002	CHI	GGOD6	ELEC-1004	120
7	1/6/2021	INV1003	TUR	GGOD7	ELEC-1005	300
8	1/7/2021	INV1001	IT	GGOD8	ELEC-1006	230
9	1/8/2021	INV1002	VIT	GGOD9	ELEC-1007	123
10	1/9/2021	INV1003	CHI	GGOD10	ELEC-1008	123
11	1/10/2021	INV1004	CHI	GGOD11	ELEC-1000	123
12	1/11/2021	INV1004	TUR	GGOD12	ELEC-1001	1122
13	1/12/2021	INV1004	IT	GGOD13	ELEC-1000	122	10
14	1/13/2021	INV1004	VIT	GGOD14	ELEC-1001		4
15	1/14/2021	INV1005	CHI	GGOD15	ELEC-1007	123
16	1/15/2021	INV1006	TUR	GGOD16	ELEC-1008	123	1
17	1/16/2021	INV1007	IT	GGOD17	ELEC-1009	11
18	1/17/2021	INV1008	VIT	GGOD18	ELEC-1010	11
19	1/18/2021	INV1009	CHI	GGOD19	ELEC-1011	12
20	1/19/2021	INV1010	TUR	GGOD20	ELEC-1012	12
21	1/20/2021	INV1011	IT	GGOD21	ELEC-1013	10	12
SHEET1

result

ورقة عمل Microsoft Excel جديد (2).xlsx
	A	B	C	D	E	F	G	H
1	ITEM	INVOICE NO	MADE	DEL.NO	BRAND	IMPORT	EXPORT	BALANCE
2	1	INV1000	CHI	GGOD2	ELEC-1000	200.00	-	200.00
3	2	INV1004	CHI	GGOD11	ELEC-1000	123.00	-	123.00
4	3	INV1004	IT	GGOD13	ELEC-1000	122.00	10.00	112.00
5	TOTAL					445.00	10.00	435.00
6	1	INV1000	TUR	GGOD3	ELEC-1001	1,200.00	-	1,200.00
7	2	INV1004	TUR	GGOD12	ELEC-1001	1,122.00	-	1,122.00
8	3	INV1004	VIT	GGOD14	ELEC-1001	-	4.00	-4.00
9	TOTAL					2,322.00	4.00	2,318.00
10	1	INV1000	IT	GGOD4	ELEC-1002	-	122.00	-122.00
11	TOTAL					-	122.00	-122.00
12	1	INV1001	VIT	GGOD5	ELEC-1003	1,200.00	-	1,200.00
13	TOTAL					1,200.00	-	1,200.00
14	1	INV1002	CHI	GGOD6	ELEC-1004	120.00	-	120.00
15	TOTAL					120.00	-	120.00
16	1	INV1003	TUR	GGOD7	ELEC-1005	300.00	-	300.00
17	TOTAL					300.00	-	300.00
18	1	INV1001	IT	GGOD8	ELEC-1006	230.00	-	-
19	TOTAL					230.00	-	230.00
20	1	INV1002	VIT	GGOD9	ELEC-1007	123.00	-	123.00
21	2	INV1005	CHI	GGOD15	ELEC-1007	123.00	-	123.00
22	TOTAL					246.00	-	246.00
23	1	INV1003	CHI	GGOD10	ELEC-1008	123.00	-	123.00
24	2	INV1006	TUR	GGOD16	ELEC-1008	123.00	1.00	122.00
25	TOTAL					246.00	1.00	245.00
26	1	INV1008	VIT	GGOD18	ELEC-1010	11.00	-	11.00
27	TOTAL					11.00	-	11.00
28	1	INV1009	CHI	GGOD19	ELEC-1011	12.00	-	12.00
29	TOTAL					12.00	-	12.00
30	1	INV1010	TUR	GGOD20	ELEC-1012	12.00	-	12.00
31	TOTAL					12.00	-	12.00
32	1	INV1011	IT	GGOD21	ELEC-1013	10.00	12.00	-2.00
33	TOTAL					12.00	-	12.00
sheet2

thanks

 

[Maklil]

I hope some body help .