Macro - Loop through rows when change total up total row

I'm not sure what I'm exactly looking for or how to search for it. Basically i have a macro which is looking at a column and splitting out by sheets for that column. This macro also sums a column after it is split out. But now I want to add another layer where it still splits by the specific column and still does the sum of all columns after split but I want to add to another sheet that I'm copying over that has totals (H) by funding (f). So for example, here is the split sheet

Column H | Column T
123456 | 0.00
123456 | 0.00
123456 | 0.00
123456 | 5.23
123456 | 6.45
123344 | 0.00
123344 | 3.00
123344 | 5.00
123344 | 0.00
123355 | 1.00
123355 | 3.00
123355 | 4.10

So basically on this new sheet
it would have these values

Funding (A) | Total (B) | Description (C)
123456 | 11.68 | March21 totals
123344 | 8.00 | March21 totals
123355 | 8.10 | March21 totals

Not sure what to call this. I would like to include in the main macro.

Originally Posted by sintek

No sample file...So can only guess...Also, no idea where the description comes from...sample file upload will be ideal...
Assumes Headers in Sheet1

Please Login or Register  to view this content.

I can do a sample file. Also would you want me to share what I have so far for my macro/VBA?

I have attached the sample file.

And here is my VBA

Please Login or Register  to view this content.

Basically I would like the macro to do the following:

From the "By Transaction" tab, add the Funding along with the subtotal to "Funding" tab - Funding # would go under column B and Subtotal would go under column C. I don't want to just copy all the values in funding and all the values in total to the "Funding" sheet. I want it to be subtotalled so the first row would be funding #123456 with the whole total for that, then the next Funding # would go in the next row with the total for those and so on. The description will come from the "Confirmation Form" tab in cell C10.

Attached is the sample with the Funding Sheet filled in correctly from the values on "By Transaction" and "Confirmation Form"