title: How to add default data to a new Excel worksheet?
body: <p>I have a table on the first worksheet of an MS Excel file. If I create a new worksheet, I would like to populate it with certain rows and columns from the table in the first worksheet. </p>
  
  <p>To be specific, if I have the following table in the first worksheet:</p>
  
  <pre><code>________________________________________________________
  | Header 1 | Header 2 | Header 3 | Header 4 | Header 5 |
  -------------------------------------------------------
  |   Data   |   Data   |   Data   |   Data   |   Data   |
  --------------------------------------------------------
  |   Data   |   Data   |   Data   |   Data   |   Data   |
  --------------------------------------------------------
  |   Data   |   Data   |   Data   |   Data   |   Data   |
  --------------------------------------------------------
  |   Data   |   Data   |   Data   |   Data   |   Data   |
  --------------------------------------------------------
  |   Data   |   Data   |   Data   |   Data   |   Data   |
  --------------------------------------------------------
  </code></pre>
  
  <p>and then I click on a new worksheet, I should have the following automatically appear:</p>
  
  <pre><code>__________________________________
  | Header 1 | Header 4 | Header 5 |
  ----------------------------------
  |   Data   |   Data   |   Data   |
  ----------------------------------
  |   Data   |   Data   |   Data   |
  ----------------------------------
  |   Data   |   Data   |   Data   |
  ----------------------------------
  |   Data   |   Data   |   Data   |
  ----------------------------------
  |   Data   |   Data   |   Data   |
  ----------------------------------
  </code></pre>
  
  <p>Any pointers to how I should go about achieving this? I would like to avoid creating macros as I am not familiar with programming in VB. But if that is the only option, I am willing to explore it.</p>