Hi Guys
I want matching sheet source based on column B with the others sheets . if there is new items in others sheets and duplicated then should merge and add to sheet source . this is a simple sample but in real world are about 1200 rows across sheets .
result in sheet resource with considering should be sort normally
I want matching sheet source based on column B with the others sheets . if there is new items in others sheets and duplicated then should merge and add to sheet source . this is a simple sample but in real world are about 1200 rows across sheets .
| CR.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | ITEM | GOODS | QTY | ||
| 2 | 1 | CCR CCR-1 BMW NH/12 | 380.00 | ||
| 3 | 2 | CR CCR-1 BMW NH/13 | 120.00 | ||
| 4 | 3 | CCR CCR-1 BMW NH/14 | 120.00 | ||
| 5 | 4 | CCR CCR-1 BMW NH/15 | 80.00 | ||
| 6 | 5 | CNR CCR-1 BMW NH/16 | 100.00 | ||
| 7 | 6 | CCR CCR-1 BMW NH/17 | 120.00 | ||
| 8 | 7 | MR CCR-1 BMW NH/18 | 101.00 | ||
| 9 | 8 | MR CCR-1 BMW NH/19 | 100.00 | ||
| 10 | 9 | MR CCR-1 BMW NH/20 | 200.00 | ||
| 11 | 10 | MR CCR-1 BMW NH/21 | 100.00 | ||
SOURCE | |||||
| CR.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | ITEM | GOODS | QTY | ||
| 2 | 1 | CCR CCR-1 BMW NH/12 | 110.00 | ||
| 3 | 2 | CR/MN CCR-1 BMW NH/BN-M | 20.00 | ||
| 4 | 3 | CCR CCR-1 BMW NH/14 | 200.00 | ||
| 5 | 4 | CCR CCR-1 BMW NH/15 | 12.00 | ||
| 6 | 5 | CNR CCR-1 BMW NH/16 | 23.00 | ||
| 7 | 6 | MN CCR/8 BMW NH*R5 | 12.00 | ||
| 8 | 7 | MR CCR-1 BMW NH/18 | 11.00 | ||
| 9 | 8 | MR CCR-1 BMW NH/19 | 100.00 | ||
| 10 | 9 | MR CCR-1 BMW NH/20 | 200.00 | ||
| 11 | 10 | MR CCR-1 BMW NH/21 | 100.00 | ||
MNF | |||||
| CR.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | ITEM | GOODS | QTY | ||
| 2 | 1 | MR CCR-1 BMW NH/21 | 1,200.00 | ||
| 3 | 2 | MR CCR-1 BMW NH/18 | 2,000.00 | ||
| 4 | 3 | MR CCR-1 BMW NH/23 | 2,800.00 | ||
| 5 | 4 | MR CCR-1 BMW NH/19 | 3,600.00 | ||
| 6 | 5 | BM CCR/K BMW NH/2*M | 4,400.00 | ||
| 7 | 6 | MR CCR-1 BMW NH/28 | 5,200.00 | ||
| 8 | 7 | MR CCR-1 BMW NH/29 | 6,000.00 | ||
| 9 | 8 | MR CCR-1 BMW NH/30 | 6,800.00 | ||
| 10 | 9 | CCR CCR-1 BMW NH/12 | 7,600.00 | ||
| 11 | 10 | CR/MN CCR-1 BMW NH/BN-M | 8,400.00 | ||
BBT | |||||
result in sheet resource with considering should be sort normally
| CR.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | ITEM | GOODS | QTY | ||
| 2 | 1 | CCR CCR-1 BMW NH/12 | 380.00 | ||
| 3 | 2 | CR CCR-1 BMW NH/13 | 120.00 | ||
| 4 | 3 | CCR CCR-1 BMW NH/14 | 120.00 | ||
| 5 | 4 | CCR CCR-1 BMW NH/15 | 80.00 | ||
| 6 | 5 | CNR CCR-1 BMW NH/16 | 100.00 | ||
| 7 | 6 | CCR CCR-1 BMW NH/17 | 120.00 | ||
| 8 | 7 | MR CCR-1 BMW NH/18 | 101.00 | ||
| 9 | 8 | MR CCR-1 BMW NH/19 | 100.00 | ||
| 10 | 9 | MR CCR-1 BMW NH/20 | 200.00 | ||
| 11 | 10 | MR CCR-1 BMW NH/21 | 100.00 | ||
| 12 | 11 | CR/MN CCR-1 BMW NH/BN-M | 8,420.00 | ||
| 13 | 12 | MN CCR/8 BMW NH*R5 | 12.00 | ||
| 14 | 13 | BM CCR/K BMW NH/2*M | 4,400.00 | ||
SOURCE | |||||
Last edited:
