Matching 2 sheets based on 3 citeria

ctiger

New member
Joined
Nov 4, 2013
Messages
16
Reaction score
0
Points
0
Excel Version(s)
2013
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
HTSCOOMID CODERptQtyTotal Value
5007200035 CNINPASINC1KOL700$3,200
5007200035CNINUNITEX44KAR170$3,043
5007200035ININPASINC1KOL250$1,600
5209516025CNCNZHEBAB788SHE100$1,840
5309190090THINUNITEX44KAR400$4,642
5309214010CNINPASINC1KOL200$3,200
5309292000CNCNGRETEX7WAN8100$71,972
SHEET 2
HTS COOMID CODERptQtyTotal Value
5007200035CNINUNITEX44KAR150$2,640
5007200035ININPASINC1KOL415$3,440
5007200095ININIDETEX30BAN125$1,550
5007903090ININJAISIL44BAN53$2,332
5202993000ININIDETEX30BAN250$2,225
5209516025CNCNZHEBAB788SHE100$1,840
5209516025INCNZHEBAB788SHE400$7,360
5212121020ININIDETEX30BAN125$1,050
5309190090THINUNITEX44KAR400$4,642
SHEET 3: ITEMS THAT MATCH HTS, COO, MID CODE FROM SHEETS 1 AND 2
HTS COOMID CODERptQtyTotal Value
5007200035ININPASINC1KOL250$1,600
5209516025CNCNZHEBAB788SHE100$1,840
5309190090THINUNITEX44KAR400$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 COOMID CODERptQtyTotal Value
5007200035CNINPASINC1KOL700$3,200
5007200035CNINUNITEX44KAR170$3,043
5309214010CNINPASINC1KOL200$3,200
5309292000CNCNGRETEX7WAN8100$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.
 
Back
Top