Delete 100000 rows based on matching the value for first row with last row

[Maklil]

Hello
I have multiple ranges in Details sheet if the second row (under header for each range contains value is the same value where is in lastrow(TOTAL) in column E or the lastrow(TOTAL) contains zero in column E then should delete the ranges , otherwise should keep the rest
I have about 100000 rows and increasable .

Merging ranges_3.xlsb
	A	B	C	D	E
1	DATE	CUSTOMER	INV NO	ITEM	QTY
2	11/11/2000	CSS-100	INV-A123	ITTT-100/AS-1	200
3	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-1	100
4	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-1	40
5	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-1	50
6	TOTAL				190
7
8
9	DATE	CUSTOMER	INV NO	ITEM	QTY
10	11/12/2000	CSS-100	INV-A123	ITTT-100/AS-2	300
11	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-2	400
12	TOTAL				400
13
14
15	DATE	CUSTOMER	INV NO	ITEM	QTY
16	11/15/2000	CSS-100	INV-A124	ITTT-100/AS-2	600
17	1/7/2023	CSS-100	INV-A124	ITTT-100/AS-2	300
18	1/7/2023	CSS-100	INV-A124	ITTT-100/AS-2	100
19	1/7/2023	CSS-100	INV-A124	ITTT-100/AS-2	200
20	TOTAL				600
21
22
23	DATE	CUSTOMER	INV NO	ITEM	QTY
24	11/17/2000	CSS-100	INV-A129	ITTT-100/AS-7	800
25	1/7/2023	CSS-100	INV-A129	ITTT-100/AS-7	500
26	1/7/2023	CSS-100	INV-A129	ITTT-100/AS-7	200
27	1/7/2023	CSS-100	INV-A129	ITTT-100/AS-7	100
28	TOTAL				0
DETAILS

should be

Merging ranges_3.xlsb
	A	B	C	D	E
1	DATE	CUSTOMER	INV NO	ITEM	QTY
2	11/11/2000	CSS-100	INV-A123	ITTT-100/AS-1	200
3	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-1	100
4	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-1	40
5	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-1	50
6	TOTAL				190
7
8
9	DATE	CUSTOMER	INV NO	ITEM	QTY
10	11/12/2000	CSS-100	INV-A123	ITTT-100/AS-2	300
11	1/7/2023	CSS-100	INV-A123	ITTT-100/AS-2	400
12	TOTAL				400
OUTPUT

thanks

 

[Peter_SSs]

You're welcome. Glad we got there in the end.
(I have edited the marked solution to include that extra line to auto-fit the columns so the whole solution is together in one post)