Most valuable professional
  • Hot Topics

Excel Add Subtotals After Each Data Break

Good morning, good afternoon and good evening to all, I can't seem to get this to insert a subtotal after each break I've created in my extract. It only installs a total after the first instance and not the others. Also, it only works in column H but I need it to install a total in column I as well. Code: ' A Dim Dim nxt I have about five breaks currently but it could vary depending on the pulled data. Thanks in advance for your generous consideration.

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of April 27, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel