none
Match Data between two excel sheets RRS feed

  • Question

  • I have two sheets  with  thousands of rows,like;

    1)

    nco_code qualification_code subject_code exchange 1_type additional_nco_code
    00010 PS PO GEN 12
    00051 PS PP    
    00065 PS E8 PEEO 8
    00066 PT M1 PEEO  
    00070 IN AD    
    00070 PS ER PEEO  
    00071 PS EA PEEO  
    00091 PS AP PEEO  
    00110 PS C7 PEEO  
    00112 PS ZW PEEO 4

    2)

    nco_code nco_description exchange 2_type
    00010 Physicist PEEO
    00065 Medical Electronics GEN

    00070 Instrumentation (M.Sc) PEEO
    00071 Electro&Communctn_MSC PEEO
    00090 Physicist, Others PEEO
    00091 APPLIED GEO PHYSICS PEEO
    00110 Chemist,General PEEO
    00111 P.G.SCIENCE (2ND) PEEO
    00112 Photonics &Biophotonics PEEO
    00150 B P O (DIP.) GEN
    00190 Chemist-others PEEO
    00210 Geologists GEN

    I want to  merge data  available in  two sheets in one sheet. The third sheet should contain  all coloumns  of sheet 1,

    (nco_code, qualification_code subject_code exchange 1_type additional_nco_code
     ) and in addition it should contain data of matching nco_code in sheet 2( 
    nco_description exchange 2_type
    )

     If nco_code available in  sheet 1 not available in sheet 2, the nco_description and exchange2_type filed should be left blank.

    The example sheet is  given below:

    nco_code qualification_code subject_code exchange_type additional_nco_code nco_description exchange_type
    00010 PS PO GEN 12 Physicist PEEO
    00051 PS PP    
    00065 PS E8 PEEO 8 Medical Electronics GEN
    00066 PT M1 PEEO      
    00070 IN AD     Instrumentation (M.Sc) PEEO
    00070 PS ER PEEO   Instrumentation (M.Sc) PEEO
    00071 PS EA PEEO   Electro&Communctn_MSC PEEO
    00091 PS AP PEEO   APPLIED GEO PHYSICS PEEO
    00110 PS C7 PEEO   Chemist,General PEEO
    00112 PS ZW PEEO 4 Photonics &Biophotonics PEEO

    Note: For nco_code 00070, two records are there.

    I want this to be done through a macro.

    Please help.

    Thank you.


    ஜெ.இரவிச்சந்திரன்

    Monday, February 4, 2019 9:48 AM

All replies