Hello
I want creating ranges when I fill userform . I have label1:lable6 and textbox1:textbox6
the label1 :label4 should be in firs row as header and textbox1: textbox4 should be under headers (label1:label4) when copy to sheet and the label 5:label6 should be in column C under textbox3(the name) when copy to sheet .
and the textbox5:textbox6 should be in column D for adjacent cell in column C based on ( label 5:label6)
when I fill userform
then should be in sheet like this
and if I add another name
and the result in sheet should copy to the bottom like this
I hope this pictures and details are clear .
thanks in advance.
I want creating ranges when I fill userform . I have label1:lable6 and textbox1:textbox6
the label1 :label4 should be in firs row as header and textbox1: textbox4 should be under headers (label1:label4) when copy to sheet and the label 5:label6 should be in column C under textbox3(the name) when copy to sheet .
and the textbox5:textbox6 should be in column D for adjacent cell in column C based on ( label 5:label6)
1.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
7 | ||||||||
8 | ||||||||
9 | ||||||||
10 | ||||||||
11 | ||||||||
12 | ||||||||
13 | ||||||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
17 | ||||||||
18 | ||||||||
19 | ||||||||
20 | ||||||||
21 | ||||||||
22 | ||||||||
EMPLOYEES |
when I fill userform
then should be in sheet like this
1.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | START DATE | LAST DATE | NAME | FIRST BALANCE | ||
2 | 01/01/2023 | 31/01/2023 | OMAR ALI OMAR | -20,000.00 | ||
3 | SALARY | 3,000.00 | ||||
4 | NET AMOUNT | -17,000.00 | ||||
EMPLOYEES |
and if I add another name
and the result in sheet should copy to the bottom like this
1.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | START DATE | LAST DATE | NAME | FIRST BALANCE | ||
2 | 01/01/2023 | 31/01/2023 | OMAR ALI OMAR | -20,000.00 | ||
3 | SALARY | 3,000.00 | ||||
4 | NET AMOUNT | -17,000.00 | ||||
5 | ||||||
6 | ||||||
7 | START DATE | LAST DATE | NAME | FIRST BALANCE | ||
8 | 01/01/2023 | 31/01/2023 | AHMED OMAR ALI | -2,000.00 | ||
9 | SALARY | 3,000.00 | ||||
10 | NET AMOUNT | 1,000.00 | ||||
EMPLOYEES |
I hope this pictures and details are clear .
thanks in advance.