Results 1 to 3 of 3

Thread: Matching 2 sheets based on 3 citeria

  1. #1

    Matching 2 sheets based on 3 citeria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Acolyte Sixthsense's Avatar
    Join Date
    Nov 2012
    Location
    India
    Posts
    26
    Articles
    0
    Instead of showing the data in the post, please attach a sample workbook by showing expected result for giving exact solution.

  3. #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
  •