create array with multiple textbox and copy to specific range based on selected combobox

[tubrak]

hi expert

I have many table in sheet1 what I want when select the name from combobox should match with col B and when fill the data in all the textboxes should fill the table based on name

about the column F the calculation should be like this the first row contain the values . balance= debit - credit and the next row should be balance = last balance +debit - credit for all tables
note: every time I create new tables in the bottom so I want the code is dynamic
original data in sheet1

1.xlsx
	A	B	C	D	E	F	G
2
3	ITEM	NAME	INVOICE NO	DEIT	CREDIT	BALANCE
4		TUBR
5		TUBR
6		TUBR
7		TUBR
8
9
10
11	ITEM	NAME	INVOICE NO	DEIT	CREDIT	BALANCE
12		TRIB
13		TRIB
14		TRIB
15		TRIB
16
17
18
19	ITEM	NAME	INVOICE NO	DEIT	CREDIT	BALANCE
20		TRANIB
21		TRANIB
22		TRANIB
SHEET1

userform

the expected result when select specific name

1.xlsx
	A	B	C	D	E	F
3	ITEM	NAME	INVOICE NO	DEIT	CREDIT	BALANCE
4	1	TUBR	AS-100	100	50	50
5	2	TUBR	AS-101	100	100	50
6	3	TUBR	AS-102	200	10	240
7	4	TUBR	AS-103	100		340
8
9
10
11	ITEM	NAME	INVOICE NO	DEIT	CREDIT	BALANCE
12		TRIB
13		TRIB
14		TRIB
15		TRIB
16
17
18
19	ITEM	NAME	INVOICE NO	DEIT	CREDIT	BALANCE
20		TRANIB
21		TRANIB
22		TRANIB
SHEET1

any help would truly appreciate