title: Copying and pasting Multiple cells in Excel VBA
body: <p>New to Excel VBA and looking for some guidance, please.</p>
  
  <p>I have the following situation in Excel.  TodayDate is today's date.  Sheet has 365 columns, one for each day of the year.  Everyday I want to run a macro that will pick out ONLY the non-zero values, then copy them, then paste them into another sheet in the same workbook.</p>
  
  <p>Worksheet A</p>
  
  <pre><code>TodayDate
  0
  45
  0
  12
  6
  0
  29
  </code></pre>
  
  <p>So the result for this particular day would be:</p>
  
  <p>Worksheet B</p>
  
  <pre><code>TodayDate
  45
  12
  6
  29
  </code></pre>
  
  <p>Note: the number of non-zero entries is variable.  Can be zero on a particular date or it can be a dozen or more.  Also, which column of interest will fall on also varies, due mostly to leap-years and the fact that I need to run it for any particular day of the year.</p>
  
  <p>I've been looking around and trying different things but have not found anything that works exactly as needed.</p>