title: Generate data in Excel using Macros?
body: <p>I need to create a table with the following structure:</p>
  
  <pre><code> Applicant | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 |
   1         |   A    |   C    |   D    |   E    |   F    |   B    |
   2         |   C    |   B    |   A    |   E    |   D    |   F    |
   3         |   C    |   A    |   F    |   E    |   B    |   D    |
   ....      |        |        |        |        |        |        |
  </code></pre>
  
  <p>Basically, test 1 - 6 can be any letter between A and F. I want a Macro (or some other method) by which I can generate this table, with 200 applicants, where the tests are completely randomised. Anyone know how to do this?</p>