title: Solution for Dividing WorkSheet into Multiple Files with vba/excel/c#
body: <p>I would like to divide a worksheet into multiple files.</p>
  
  <p>I have a worksheet with about 10,000 rows. there is fancy formatting, conditional formatting, nice colors, and I want to preserve all of these attributes.</p>
  
  <p>I need to divide this worksheet up.</p>
  
  <p>the input would be:</p>
  
  <pre><code>+-------+----+----+----+----+
  | Alex  | 45 |  6 | 23 | 56 |
  | Alex  | 61 | 47 | 56 | 56 |
  | Liza  | 49 | 70 | 34 | 37 |
  | Alex  | 33 | 30 | 22 | 39 |
  | Tommy |    | 66 | 62 | 29 |
  | Liza  |    | 38 | 49 | 80 |
  | Alex  | 23 | 56 | 56 | 39 |
  | Liza  | 32 | 46 | 40 | 43 |
  | Liza  |    | 90 | 24 | 38 |
  | Tommy | 38 | 10 | 52 | 23 |
  | Nancy | 35 | 36 | 23 | 25 |
  +-------+----+----+----+----+
  </code></pre>
  
  <p>and the output would be separate files like this (please keep in mind i want to preserve all the fancy formatting, and thus the solution has work directly with excel, and not with just CSV (because csv cannot retain formatting))</p>
  
  <p>end products:</p>
  
  <pre><code>+------+----+----+----+----+
  |      |    |    |    |    |
  | Alex | 45 |  6 | 23 | 56 |
  | Alex | 61 | 47 | 56 | 56 |
  | Alex | 33 | 30 | 22 | 39 |
  | Alex | 23 | 56 | 56 | 39 |
  +------+----+----+----+----+
  </code></pre>
  
  <p>and</p>
  
  <pre><code>+------+----+----+----+----+
  |      |    |    |    |    |
  | Liza | 49 | 70 | 34 | 37 |
  | Liza |    | 38 | 49 | 80 |
  | Liza | 32 | 46 | 40 | 43 |
  | Liza |    | 90 | 24 | 38 |
  +------+----+----+----+----+
  </code></pre>
  
  <p>and</p>
  
  <pre><code>+-------+----+----+----+----+
  |       |    |    |    |    |
  | Nancy | 35 | 36 | 23 | 25 |
  +-------+----+----+----+----+
  </code></pre>
  
  <p>and</p>
  
  <pre><code>+-------+----+----+----+----+
  |       |    |    |    |    |
  | Tommy |    | 66 | 62 | 29 |
  | Tommy | 38 | 10 | 52 | 23 |
  +-------+----+----+----+----+
  </code></pre>
  
  <p>the solution can be a combination of VBA/.NET. please note that i need  multiple files as outputs.</p>
  
  <p>what is the quickest way to get this working? thanks so much for any input!</p>
  
  <p>please note that this is excel 2007 and later</p>