title: Excel - Macro to compare /match multiple cells in a row between two sheets, and copy the entire row to the second sheet
body: <p>i'm looking for macro to match multiple cells in a row between two sheets, and copy the entire matched row from the first sheet to place beside the matched row from the second sheet.</p>
  
  <p>Below are excerpts of my excel worksheet:</p>
  
  <p>worksheet A:</p>
  
  <pre><code>    E       F   H          J
  </code></pre>
  
  <p>2878     3/1/2011 Cash  1/3/2011_BSJ  636 </p>
  
  <p>worksheet B:</p>
  
  <pre><code>   A      C        E   F
  </code></pre>
  
  <p>50       1-Mar-11 DEP_CASH  636      TRAX_BRH_BSJ</p>
  
  <p>For example if F2878 (row no. 2878, column F), E2878, J2878, H2878 of worksheet A = C50, A50, E50, F50 of worksheet B then copy whole 2878 row of worksheet A to I50 of worksheet B. Then strike through the 2878 row from worksheet A to indicate work done of a row. Note that some of the content might not exactly the same, like F2878 contains "Cash" &amp; C50 contain "CASH" out of "DEP_CASH" which are considered matched. I need to match some 3000+ row. Please help...  </p>