hi
I need code merge duplicate items based on COL B in two sheets so when merge values in COL G as two sheets should show in listbox and subtracting between two columns in list box
as in last column in listbox
sheet1
sheet2
expected result in listbox
I need code merge duplicate items based on COL B in two sheets so when merge values in COL G as two sheets should show in listbox and subtracting between two columns in list box
as in last column in listbox
sheet1
| COLLECT COL.xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | DATE | BBT | INV NO | NAME | QTY | PRICE | TOTAL | ||
| 2 | 1/1/2021 | bfg-hy1 | invn-as1 | asz-1 | 200.00 | $350.00 | $70,000.00 | ||
| 3 | 1/2/2021 | bfg-hy2 | invn-as2 | asz-2 | 65.00 | $600.00 | $39,000.00 | ||
| 4 | 1/3/2021 | bfg-hy3 | invn-as3 | asz-3 | 80.00 | $700.00 | $56,000.00 | ||
| 5 | 1/4/2021 | bfg-hy4 | invn-as4 | asz-4 | 54.00 | $500.00 | $27,000.00 | ||
| 6 | 1/5/2021 | bfg-hy5 | invn-as5 | asz-5 | 34.00 | $400.00 | $13,600.00 | ||
| 7 | 1/6/2021 | bfg-hy6 | invn-as6 | asz-6 | 12.00 | $200.00 | $2,400.00 | ||
| 8 | 1/7/2021 | bfg-hy1 | invn-as7 | asz-1 | 45.00 | $400.00 | $18,000.00 | ||
| 9 | 1/8/2021 | bfg-hy2 | invn-as8 | asz-2 | 78.00 | $500.00 | $39,000.00 | ||
| 10 | 1/9/2021 | bfg-hy3 | invn-as9 | asz-3 | 54.00 | $900.00 | $48,600.00 | ||
| 11 | 1/10/2021 | bfg-hy4 | invn-as10 | asz-4 | 21.00 | $800.00 | $16,800.00 | ||
| 12 | 1/11/2021 | bfg-hy5 | invn-as11 | asz-5 | 55.00 | $670.00 | $36,850.00 | ||
| 13 | 1/12/2021 | bfg-hy6 | invn-as12 | asz-6 | 66.00 | $431.00 | $28,446.00 | ||
sheet1 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G13 | G2 | =E2*F2 |
sheet2
| COLLECT COL.xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | DATE | BBT | INV NO | NAME | QTY | PRICE | TOTAL | ||
| 2 | 1/1/2021 | bfg-hy1 | invn-as1 | asz-1 | 200.00 | $400.00 | $80,000.00 | ||
| 3 | 1/2/2021 | bfg-hy2 | invn-as2 | asz-2 | 65.00 | $700.00 | $45,500.00 | ||
| 4 | 1/3/2021 | bfg-hy3 | invn-as3 | asz-3 | 80.00 | $800.00 | $64,000.00 | ||
| 5 | 1/4/2021 | bfg-hy4 | invn-as4 | asz-4 | 54.00 | $800.00 | $43,200.00 | ||
| 6 | 1/5/2021 | bfg-hy5 | invn-as5 | asz-5 | 34.00 | $700.00 | $23,800.00 | ||
| 7 | 1/6/2021 | bfg-hy6 | invn-as6 | asz-6 | 12.00 | $600.00 | $7,200.00 | ||
| 8 | 1/7/2021 | bfg-hy1 | invn-as7 | asz-1 | 45.00 | $400.00 | $18,000.00 | ||
| 9 | 1/8/2021 | bfg-hy2 | invn-as8 | asz-2 | 78.00 | $700.00 | $54,600.00 | ||
| 10 | 1/9/2021 | bfg-hy3 | invn-as9 | asz-3 | 54.00 | $1,000.00 | $54,000.00 | ||
| 11 | 1/10/2021 | bfg-hy4 | invn-as10 | asz-4 | 21.00 | $1,000.00 | $21,000.00 | ||
| 12 | 1/11/2021 | bfg-hy5 | invn-as11 | asz-5 | 55.00 | $700.00 | $38,500.00 | ||
| 13 | 1/12/2021 | bfg-hy6 | invn-as12 | asz-6 | 66.00 | $800.00 | $52,800.00 | ||
Sheet2 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G13 | G2 | =E2*F2 |
expected result in listbox
