I need to "massage" a report from main frame. Here is the layout

Start at Row 1 column A

Row1 T1T1T1
Row2 B2......C2
Row3 B3......C3
Row4 Total T1T1T1 sum(c2:c3) in C4

etc.....

What I need


Row1 T1T1T1 B2......C2
Row2 T1T1T1 B3......C3 and verify that sum C4
is correct by summing c2&c3 in VBA and comparing it with the last row in the first group in C4


I have several groups following that, and same structure.


Any Guidance will be greatly appreciated