title: How do you make a dynamically-sized data table?
body: <p>I am using Excel 2010.</p>
  
  <p>I have a "monthly" data table that looks similar to this:</p>
  
  <pre><code>MonthBegin    InventoryExpenses  Overhead  TotalSales  TotalSalesIncome  TotalProfit
  July-11       $1,500             $4,952    89          $7,139            $687
  August-11     $2,200             $4,236    105         $8,312            $1,876
  September-11  $1,100             $4,429    74          $6,691            $1,162
  </code></pre>
  
  <p>The following formula is automatically propogated to every cell in the [MonthBegin] column:</p>
  
  <pre><code>=DATE( 2011, 7 + ( ROW( ) - 2 ), 1 )
  </code></pre>
  
  <p>Every other colmun has a similar column-formula that automatically pulls the appropriate data from another source, <strong>based on the month listed in the [MonthBegin] column</strong>.</p>
  
  <p>With this configuration, I can just insert a new row anywhere into the table and the next month will automatically appear at the bottom in the correct order (which I find nifty).</p>
  
  <p>But I need to take this to the next level of automation, to please management.<br>
  How can I make it so that the spreadsheet automatically adds a row for October once the month is over?</p>
  
  <p>I've been considering using a dynamic range for the table:</p>
  
  <pre><code>=OFFSET(A1,0,0,( ( YEAR( TODAY( ) ) - 2011 ) * 12 ) + ( MONTH( TODAY( ) ) - 7 ),6)
  </code></pre>
  
  <p>... but Excel won't accept such a formula for the table area, I assume because it is not static.<br>
  Can anyone explain to me how to gain this functionality with my data table?</p>