Loop & formula

[dems]

Hi guys,

Struggling with a loop and formula and would greatly appreciate any advice. To start, I have two three columns in my book -

Col. A splits the fields by their respective group name
Col. B splits each group name into distinct coverage groups
Col. C reflects revenue for each coverage group within its group. Each group's total row should be the sum of the non-Total coverage.


The majority of groups have a coverage line called NON INDUSTRY SPECIFIC. I would like to use this number to balance the difference between the TOTAL and the sum of the coverage. I have made an example attachment which should hopefully explain the above more effectively.

Thanks for your time and help.
D

[mrice]

I've created a user defined formula which you will find on the module1 tab in the VBA editor (Alt F11).