title: VBA Insert Line After Data Change and Sum Data Group
body: <p>I have a client with a long report of data that I am writing a VBA script to simplify.  What they would like is <em>after</em> each group of clients, a blank row is inserted. This is satisfied by:    </p>
  
  <pre><code>Dim lRow As Long
  For lRow = Cells(Cells.Rows.Count, "C").End(xlUp).Row To 3 Step -1
      If Cells(lRow, "C") &lt;&gt; Cells(lRow - 1, "C") Then Rows(lRow).EntireRow.Insert
  Next lRow
  </code></pre>
  
  <p>Now, in this empty row, I need an AutoSum of the values in Column F for the preceding group (i.e. the data leading to the blank row). </p>
  
  <p>I've been trying to use the blank special cell type but can't seem to get anything to work.  Any advice would be greatly appreciated.</p>
  
  <p>Thanks in advance!</p>