Instead of showing the data in the post, please attach a sample workbook by showing expected result for giving exact solution.
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
Instead of showing the data in the post, please attach a sample workbook by showing expected result for giving exact solution.
Sorry, not allowed by co. policy to send out attachments.
Bookmarks