Subtotal by Funding on one sheet but put the results on another sheet

[mlindquist]

What I'm trying to do is create a macro that does the following:
1. On the "By Transaction" worksheet sort by the Funding column .
2. Subtotal by Total Amount Due by a change of Funding
3. Copy the Funding and Total Amount Due Subtotal onto another sheet "By Funding" where there are other fields to be filled in but those values are easy to get.

Here is an example of the By Transaction Sheet

Date	Campus	Funding	Item Description	Total Amount Due
March 1-March 31, 2021	UWABC	123-4-12345	Item 1	0.00
March 1-March 31, 2021	UWABC	123-4-12345	Item 2	0.55
March 1-March 31, 2021	UWABC	123-4-12345	Item 3	1.14
March 1-March 31, 2021	UWABC	123-4-12345	Item 4	6.57
March 1-March 31, 2021	UWABC	155-1-11223	Item 1	1.25
March 1-March 31, 2021	UWABC	155-1-11223	Item 2	5.55
March 1-March 31, 2021	UWABC	155-1-11223	Item 3	0.00
March 1-March 31, 2021	UWABC	155-1-11223	Item 4	0.25
March 1-March 31, 2021	UWABC	155-1-11223	Item 5	12.00
March 1-March 31, 2021	UWABC	167-5-12345	Item 1	4.25
March 1-March 31, 2021	UWABC	167-5-12345	Item 2	5.00
March 1-March 31, 2021	UWABC	167-5-12345	Item 3	10.11
March 1-March 31, 2021	UWABC	and so on

After the macro runs this is what the By Funding page would look like (there are additional columns to populate but those are being taking from a header on another sheet):

Campus	Funding	Total Amount Due
UWABC	123-4-12345	8.26
UWABC	155-1-11223	19.05
UWABC	167-5-12345	19.36

 

[mlindquist]

Just an FYI... I posted a similar question to another forum - Macro - Loop through rows when change total up total row. I'm not just not sure to ask for what I want and I think my post here makes a little more sense.