title: Excel macro to find duplicates and copy their adjacent cells
body: <p>I need a macro that loops column C and locates the duplicate values and copies them to col D, once a duplicate value is located it would copy the adjacent value from Col A and place it in Col E </p>
  
  <p>example desired output:</p>
  
  <pre><code>A                 B                C              D            E
  Project1          test1            quiz1         quiz1        Project1
  Project2          test2            quiz1         quiz1        Project2
  Project3          test3            quiz2
  </code></pre>