Thread: Matching 2 sheets based on 3 citeria

1. Matching 2 sheets based on 3 citeria

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

2. Instead of showing the data in the post, please attach a sample workbook by showing expected result for giving exact solution.

3. Sorry, not allowed by co. policy to send out attachments.

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•