Match combobox name on userform with shee name and fill empty cell

[Maklil]

Hello
I want matching combobox1 name with sheet name , if matched the name then should search for empty cell in column D and if I select optionbutton1(PAID) or optionbutton1(NOT PAID) then will auto fill except the last row where contains TOTAL word in column A
here is example
data in sheets

Maklil.xlsx
	A	B	C	D	E	F	G
1	DATE	INV NNO	ID	CASE	QTY	UNIT PRICE	BALANCE
2	21/08/2023	VT NO 1000	FOO LL 1000		220.00	123.00	27,060.00
3	21/08/2023	VT NO 1000	GNOO HH 1200		100.00	122.00	12,200.00
4	21/08/2023	VT NO 1000	AS100-12		120.00	111.00	13,320.00
5	TOTAL						52,580.00
6	21/08/2023	VT NO 1001	MGFH GA-100	NOT PAID	100.00	110.00	11,000.00
7	21/08/2023	VT NO 1001	MGFH GA-101	NOT PAID	120.00	111.00	13,320.00
8	21/08/2023	VT NO 1001	MGFH GA-102	NOT PAID	110.00	110.00	12,100.00
9	21/08/2023	VT NO 1001	MGFH GA-103	NOT PAID	12.00	100.00	1,200.00
10	TOTAL						37,620.00
11	21/08/2023	VT NO 1002	SSFOO 1000 MN1	NOT PAID	20.00	124.00	2,480.00
12	21/08/2023	VT NO 1002	SSFOO 1000 MN2	NOT PAID	30.00	122.00	3,660.00
13	21/08/2023	VT NO 1002	SSFOO 1000 MN3	NOT PAID	24.00	124.00	2,976.00
14	21/08/2023	VT NO 1002	SSFOO 1000 MN4	NOT PAID	22.00	125.00	2,750.00
15	21/08/2023	VT NO 1002	SSFOO 1000 MN5	NOT PAID	10.00	144.00	1,440.00
16	TOTAL						13,306.00
17	21/08/2023	VT NO 1003	OOIL AS-100		10.00	145.00	1,450.00
18	21/08/2023	VT NO 1003	OOIL AS-101		25.00	150.00	3,750.00
19	21/08/2023	VT NO 1003	OOIL AS-102		40.00	155.00	6,200.00
20	21/08/2023	VT NO 1003	OOIL AS-103		55.00	160.00	8,800.00
21	21/08/2023	VT NO 1003	OOIL AS-104		70.00	165.00	11,550.00
22	21/08/2023	VT NO 1003	OOIL AS-105		85.00	170.00	14,450.00
23	21/08/2023	VT NO 1003	OOIL AS-106		100.00	175.00	17,500.00
24	21/08/2023	VT NO 1003	OOIL AS-107		115.00	180.00	20,700.00
25	TOTAL						84,400.00
26	22/08/2023	VT NO 1004	OOIL AS-108	PAID	130.00	185.00	24,050.00
27	22/08/2023	VT NO 1004	OOIL AS-109	PAID	145.00	190.00	27,550.00
28	22/08/2023	VT NO 1004	OOIL AS-110	PAID	160.00	195.00	31,200.00
29	22/08/2023	VT NO 1004	OOIL AS-111	PAID	175.00	200.00	35,000.00
30	22/08/2023	VT NO 1004	OOIL AS-112	PAID	190.00	205.00	38,950.00
31	22/08/2023	VT NO 1004	OOIL AS-113	PAID	205.00	210.00	43,050.00
32	22/08/2023	VT NO 1004	OOIL AS-114	PAID	220.00	215.00	47,300.00
33	TOTAL						247,100.00
BUYING

Cell Formulas
Range	Formula
G26:G32,G17:G24,G6:G9,G2:G4	G2	=E2*F2
G5	G5	=SUM(G2:G4)
G10	G10	=SUM(G6:G9)
G11:G15	G11	=F11*E11
G16	G16	=SUM(G11:G15)
G25	G25	=SUM(G17:G24)
G33	G33	=SUM(G26:G32)

Maklil.xlsx
	A	B	C	D	E	F	G
1	DATE	INV NNO	ID	CASE	QTY	UNIT PRICE	BALANCE
2	21/08/2023	ST NO 1000	GNOO HH 1200	PAID	10.00	150.00	1,500.00
3	21/08/2023	ST NO 1000	AS100-12	PAID	10.00	130.00	1,300.00
4	TOTAL						2,800.00
5	21/08/2023	ST NO 1001	MGFH GA-103	NOT PAID	15.00	130.00	1,950.00
6	TOTAL						1,950.00
7	21/08/2023	ST NO 1002	SSFOO 1000 MN1	NOT PAID	2.00	140.00	280.00
8	21/08/2023	ST NO 1002	SSFOO 1000 MN2	NOT PAID	12.00	145.00	1,740.00
9	21/08/2023	ST NO 1002	SSFOO 1000 MN3	NOT PAID	10.00	145.00	1,450.00
10	TOTAL						3,470.00
11	24/08/2023	VT NO 1003	OOIL AS-100		10.00	145.00	1,450.00
12	24/08/2023	VT NO 1003	OOIL AS-101		25.00	150.00	3,750.00
13	24/08/2023	VT NO 1003	OOIL AS-102		40.00	155.00	6,200.00
14	24/08/2023	VT NO 1003	OOIL AS-103		55.00	160.00	8,800.00
15	24/08/2023	VT NO 1003	OOIL AS-104		70.00	165.00	11,550.00
16	24/08/2023	VT NO 1003	OOIL AS-105		85.00	170.00	14,450.00
17	24/08/2023	VT NO 1003	OOIL AS-106		100.00	175.00	17,500.00
18	24/08/2023	VT NO 1003	OOIL AS-107		115.00	180.00	20,700.00
19	TOTAL						84,400.00
SELLING

Cell Formulas
Range	Formula
G11:G18,G5,G2:G3	G2	=E2*F2
G4	G4	=SUM(G2:G3)
G6	G6	=SUM(G5:G5)
G7:G9	G7	=F7*E7
G10	G10	=SUM(G7:G9)
G19	G19	=SUM(G11:G18)

when select sheet (BUYING) from combobox1 and optionbutton1 (PAID)

RESULT

Maklil.xlsx
	A	B	C	D	E	F	G	H
1	DATE	INV NNO	ID	CASE	QTY	UNIT PRICE	BALANCE
2	21/08/2023	VT NO 1000	FOO LL 1000	PAID	220.00	123.00	27,060.00
3	21/08/2023	VT NO 1000	GNOO HH 1200	PAID	100.00	122.00	12,200.00
4	21/08/2023	VT NO 1000	AS100-12	PAID	120.00	111.00	13,320.00
5	TOTAL						52,580.00
6	21/08/2023	VT NO 1001	MGFH GA-100	NOT PAID	100.00	110.00	11,000.00	BUYING
7	21/08/2023	VT NO 1001	MGFH GA-101	NOT PAID	120.00	111.00	13,320.00	SELLING
8	21/08/2023	VT NO 1001	MGFH GA-102	NOT PAID	110.00	110.00	12,100.00
9	21/08/2023	VT NO 1001	MGFH GA-103	NOT PAID	12.00	100.00	1,200.00
10	TOTAL						37,620.00
11	21/08/2023	VT NO 1002	SSFOO 1000 MN1	NOT PAID	20.00	124.00	2,480.00
12	21/08/2023	VT NO 1002	SSFOO 1000 MN2	NOT PAID	30.00	122.00	3,660.00
13	21/08/2023	VT NO 1002	SSFOO 1000 MN3	NOT PAID	24.00	124.00	2,976.00
14	21/08/2023	VT NO 1002	SSFOO 1000 MN4	NOT PAID	22.00	125.00	2,750.00
15	21/08/2023	VT NO 1002	SSFOO 1000 MN5	NOT PAID	10.00	144.00	1,440.00
16	TOTAL						13,306.00
17	21/08/2023	VT NO 1003	OOIL AS-100	PAID	10.00	145.00	1,450.00
18	21/08/2023	VT NO 1003	OOIL AS-101	PAID	25.00	150.00	3,750.00
19	21/08/2023	VT NO 1003	OOIL AS-102	PAID	40.00	155.00	6,200.00
20	21/08/2023	VT NO 1003	OOIL AS-103	PAID	55.00	160.00	8,800.00
21	21/08/2023	VT NO 1003	OOIL AS-104	PAID	70.00	165.00	11,550.00
22	21/08/2023	VT NO 1003	OOIL AS-105	PAID	85.00	170.00	14,450.00
23	21/08/2023	VT NO 1003	OOIL AS-106	PAID	100.00	175.00	17,500.00
24	21/08/2023	VT NO 1003	OOIL AS-107	PAID	115.00	180.00	20,700.00
25	TOTAL						84,400.00
26	22/08/2023	VT NO 1004	OOIL AS-108	PAID	130.00	185.00	24,050.00
27	22/08/2023	VT NO 1004	OOIL AS-109	PAID	145.00	190.00	27,550.00
28	22/08/2023	VT NO 1004	OOIL AS-110	PAID	160.00	195.00	31,200.00
29	22/08/2023	VT NO 1004	OOIL AS-111	PAID	175.00	200.00	35,000.00
30	22/08/2023	VT NO 1004	OOIL AS-112	PAID	190.00	205.00	38,950.00
31	22/08/2023	VT NO 1004	OOIL AS-113	PAID	205.00	210.00	43,050.00
32	22/08/2023	VT NO 1004	OOIL AS-114	PAID	220.00	215.00	47,300.00
33	TOTAL						247,100.00
BUYING

Cell Formulas
Range	Formula
G26:G32,G17:G24,G6:G9,G2:G4	G2	=E2*F2
G5	G5	=SUM(G2:G4)
G10	G10	=SUM(G6:G9)
G11:G15	G11	=F11*E11
G16	G16	=SUM(G11:G15)
G25	G25	=SUM(G17:G24)
G33	G33	=SUM(G26:G32)

when select sheet (SELLING) from combobox1 and optionbutton1 (NOT PAID)

result

Maklil.xlsx
	A	B	C	D	E	F	G
1	DATE	INV NNO	ID	CASE	QTY	UNIT PRICE	BALANCE
2	21/08/2023	ST NO 1000	GNOO HH 1200	PAID	10.00	150.00	1,500.00
3	21/08/2023	ST NO 1000	AS100-12	PAID	10.00	130.00	1,300.00
4	TOTAL						2,800.00
5	21/08/2023	ST NO 1001	MGFH GA-103	NOT PAID	15.00	130.00	1,950.00
6	TOTAL						1,950.00
7	21/08/2023	ST NO 1002	SSFOO 1000 MN1	NOT PAID	2.00	140.00	280.00
8	21/08/2023	ST NO 1002	SSFOO 1000 MN2	NOT PAID	12.00	145.00	1,740.00
9	21/08/2023	ST NO 1002	SSFOO 1000 MN3	NOT PAID	10.00	145.00	1,450.00
10	TOTAL						3,470.00
11	24/08/2023	VT NO 1003	OOIL AS-100	NOT PAID	10.00	145.00	1,450.00
12	24/08/2023	VT NO 1003	OOIL AS-101	NOT PAID	25.00	150.00	3,750.00
13	24/08/2023	VT NO 1003	OOIL AS-102	NOT PAID	40.00	155.00	6,200.00
14	24/08/2023	VT NO 1003	OOIL AS-103	NOT PAID	55.00	160.00	8,800.00
15	24/08/2023	VT NO 1003	OOIL AS-104	NOT PAID	70.00	165.00	11,550.00
16	24/08/2023	VT NO 1003	OOIL AS-105	NOT PAID	85.00	170.00	14,450.00
17	24/08/2023	VT NO 1003	OOIL AS-106	NOT PAID	100.00	175.00	17,500.00
18	24/08/2023	VT NO 1003	OOIL AS-107	NOT PAID	115.00	180.00	20,700.00
19	TOTAL						84,400.00
SELLING

Cell Formulas
Range	Formula
G11:G18,G5,G2:G3	G2	=E2*F2
G4	G4	=SUM(G2:G3)
G6	G6	=SUM(G5:G5)
G7:G9	G7	=F7*E7
G10	G10	=SUM(G7:G9)
G19	G19	=SUM(G11:G18)