title: excel vba programming for list comparison of same sheet
body: <p>here the two list in a sheet i want the list with data of list 1 and extra data from list 2. please suggest the code. thanks</p>
  
  <p>list 1 (column a,b,c)       </p>
  
  <pre>
  A       B        C
  name    class    marks
  a       1        12
  b       2        13
  c       5        14
  d       4        15
  </pre>
  
  <p>list 2 (column d e f)</p>
  
  <pre>
  D       E       F
  name    class   marks
  z        2      4
  d        6      2
  c        8      6
  x        9      8
  </pre>
  
  <p>result (keep list 1 and extra from list 2 in column g h i)      </p>
  
  <pre>
  G       H       I
  name    class   marks
  a        1      12
  b        2      13
  c        5      14
  d        4      15
  z        2      4
  x        9      8
  </pre>