6 Replies Latest reply: Oct 26, 2012 6:32 AM by Anirban Guha RSS

    Loading uniform codes from separate excel sheets

      Hi Everyone,

       

      I have 3 excel sheets in which i have a large chunk of data. The data is represented by their codes. For the first 2 sheets, i have all those codes which i want for my report but in the third sheet there are many unwanted codes which i don't want. Please suggest me a way, so that i can get only those codes into my script which are there in the first 2 sheets. Pls see the below example for your refence-

       

      Excel Sheet 1
      Excel Sheet 2
      Excel Sheet 3
      610110610110502312
      622122622122610110
      640641640641509876
      633622633622640641
      633650633650633622

       

      I want only those codes which are there in the first two sheets.

       

      Thanks

      Anirban