Hello All, have sheets 1 and 2 and need to match based on 3 criteria: HTS, COO and MID CODE. If there is a match then dump data in sheet 3. If no match then dump remaining items from sheet 1 only into sheet 4. Is there a Macro I can use for this?
SHEET 1 | ||||
HTS | COO | MID CODE | RptQty | Total Value |
5007200035 | CN | INPASINC1KOL | 700 | $3,200 |
5007200035 | CN | INUNITEX44KAR | 170 | $3,043 |
5007200035 | IN | INPASINC1KOL | 250 | $1,600 |
5209516025 | CN | CNZHEBAB788SHE | 100 | $1,840 |
5309190090 | TH | INUNITEX44KAR | 400 | $4,642 |
5309214010 | CN | INPASINC1KOL | 200 | $3,200 |
5309292000 | CN | CNGRETEX7WAN | 8100 | $71,972 |
SHEET 2 | ||||
HTS | COO | MID CODE | RptQty | Total Value |
5007200035 | CN | INUNITEX44KAR | 150 | $2,640 |
5007200035 | IN | INPASINC1KOL | 415 | $3,440 |
5007200095 | IN | INIDETEX30BAN | 125 | $1,550 |
5007903090 | IN | INJAISIL44BAN | 53 | $2,332 |
5202993000 | IN | INIDETEX30BAN | 250 | $2,225 |
5209516025 | CN | CNZHEBAB788SHE | 100 | $1,840 |
5209516025 | IN | CNZHEBAB788SHE | 400 | $7,360 |
5212121020 | IN | INIDETEX30BAN | 125 | $1,050 |
5309190090 | TH | INUNITEX44KAR | 400 | $4,642 |
SHEET 3: ITEMS THAT MATCH HTS, COO, MID CODE FROM SHEETS 1 AND 2 | ||||
HTS | COO | MID CODE | RptQty | Total Value |
5007200035 | IN | INPASINC1KOL | 250 | $1,600 |
5209516025 | CN | CNZHEBAB788SHE | 100 | $1,840 |
5309190090 | TH | INUNITEX44KAR | 400 | $4,642 |
SHEET 4: REMAINDER OF ITEMS FROM SHEET 1 ONLY THAT DO NOT MATCH HTS, COO, MID CODE FROM SHEETS 1 AND 2 | ||||
HTS | COO | MID CODE | RptQty | Total Value |
5007200035 | CN | INPASINC1KOL | 700 | $3,200 |
5007200035 | CN | INUNITEX44KAR | 170 | $3,043 |
5309214010 | CN | INPASINC1KOL | 200 | $3,200 |
5309292000 | CN | CNGRETEX7WAN | 8100 | $71,972 |