Hello
I want matching selected comboboxes on userform with sheet B: E and summing or subtraction based on selected from combobox 20
so the numbers for comboboxes & textboxes will be for each row on userform like this
combobox1 combobox2 combobox3 combobox4 ,textbox1
combobox5 combobox6 combobox7 combobox8,textbox2
combobox9 combobox10 combobox11 combobox12,textbox3
the data in sheet
when select combobox 20 SALES
so should subtract the QTY from textboxes to column F
to become in column F
when select RET1
the data in sheet
so should subtract the QTY from textboxes to column F
to become in column F
when select PURCHASE from combobox20
the data in sheet
so should summing the QTY from textboxes to column F
to become in column F
when select RET2 from combobox20
data in sheet
so should summing the QTY from textboxes to column F
to become in column F
I hope this clear .
I want matching selected comboboxes on userform with sheet B: E and summing or subtraction based on selected from combobox 20
so the numbers for comboboxes & textboxes will be for each row on userform like this
combobox1 combobox2 combobox3 combobox4 ,textbox1
combobox5 combobox6 combobox7 combobox8,textbox2
combobox9 combobox10 combobox11 combobox12,textbox3
the data in sheet
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 1,000.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 2,000.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 3,000.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,000.00 | ||
STOCK | ||||||||
when select combobox 20 SALES
so should subtract the QTY from textboxes to column F
to become in column F
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 500.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 1,500.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 2,500.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,000.00 | ||
STOCK | ||||||||
when select RET1
the data in sheet
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 500.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 1,500.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 2,500.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,000.00 | ||
STOCK | ||||||||
so should subtract the QTY from textboxes to column F
to become in column F
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 400.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 1,400.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 2,500.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,000.00 | ||
STOCK | ||||||||
when select PURCHASE from combobox20
the data in sheet
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 400.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 1,400.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 2,500.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,000.00 | ||
STOCK | ||||||||
so should summing the QTY from textboxes to column F
to become in column F
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 420.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 1,400.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 2,520.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,020.00 | ||
STOCK | ||||||||
when select RET2 from combobox20
data in sheet
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 420.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 1,400.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 2,520.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,020.00 | ||
STOCK | ||||||||
so should summing the QTY from textboxes to column F
to become in column F
| combobox2.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ITEM | BATCH | INVOICE NO | ORDER NO | CUSTOMER NO | QTY | ||
| 2 | 1 | DD-AA-1 | INV-TR1 | ORD-NN-1 | CUST-1 | 420.00 | ||
| 3 | 2 | DD-AA-2 | INV-TR2 | ORD-NN-2 | CUST-2 | 1,400.00 | ||
| 4 | 3 | DD-AA-3 | INV-TR3 | ORD-NN-3 | CUST-3 | 2,550.00 | ||
| 5 | 4 | DD-AA-4 | INV-TR4 | ORD-NN-4 | CUST-4 | 4,020.00 | ||
STOCK | ||||||||
I hope this clear .
