title: How to split a spreadsheet into multiple new spreadsheets each containing a subset of the original data?
body: <p>My excel spreadsheet contains </p>
  
  <pre><code>Name   Grade   Status
  Paul   3       M
  Paul   3       P
  Paul   4       P
  Steve  5       O
  Steve  5       O
  Nick   6       O
   ........
  </code></pre>
  
  <p>I used <code>freeze panel</code> and other formatting things . </p>
  
  <hr>
  
  <p>I want to create separate Spreadsheets that would contains only one name. Example:</p>
  
  <ol>
  <li><p>Spreadsheet_paul.xls</p>
  
  <pre><code>Name   Grade   Status
  Paul   3       M
  Paul   3       P
  Paul   4       P
  </code></pre></li>
  <li><p>Spreadsheet_Nick.xls</p>
  
  <pre><code>Name   Grade   Status
  Nick   6       o
  </code></pre>
  
  <p>.........</p></li>
  </ol>
  
  <p>I need to create separate files, with the number of files at the end equal to the number of names in the original spreadsheet, each containing the corresponding subset of the original data.</p>
  
  <p>How can I do this ?</p>