Insert sum on the first blank row after each section of data

[spacecaptainsuperguy]

I've got a spreadsheet with a bunch of loan information on it that I'm breaking apart into sections by loan number. I've got my code already in place to go down the loan number column (column A) and add a few blank rows at every change in loan number. My goal is to add a sum formula (column E) on the first blank row for that section of data on that particular loan and use the next couple of rows for some comparative data. I'm having a hard time figuring out the code to do this part. Essentially it needs to go down each section of data, find the blank row after it, add a sum formula for that section and then keep going down the spreadsheet for each successive section until it gets to the end.

Any ideas on how to code that?
Thanks in advance.

 

[spacecaptainsuperguy]

Here is what it looks like at this point

Test.xlsx
	A	B	C	D	E
6	Loan Number	Account Number	Borrower Name	Property	Principal Balance
7	2168	SEM-008	Name 1	TR. 25	$59,380.93
8	2168	SEM-016	Name 2	TR. 26	$44,852.12
9	2168	SEM-020	Name 3	TR. 4	$41,995.64
10	2168	SEM-028	Name 4	TR. 9	$40,644.30
11	2168	SEM-031	Name 5	TR. 35	$32,659.59
12	2168	SEM-051	Name 6	TR. 30 & 31	$96,263.44
13	2168	SEM-063	Name 7	TR. 2 & 3	$77,659.54
14
15
16
17
18	3795	ORR-009	Name 8	TR. 14	$42,682.68
19	3795	ORR-010	Name 9	TR. 4	$40,370.78
20	3795	ORR-021	Name 10	TR. 5	$51,404.26
21	3795	ORR-022	Name 11	TR. 6	$51,115.84
22	3795	ORR-028	Name 12	TR. 18	$58,650.98
23
24
25
26
27	3796	WEST-002	Name 13	TR. 19, 20 & 21	$113,471.29
28	3796	WEST-013	Name 14	TR. 8	$38,514.93
29	3796	WEST-015	Name 15	TR. 9	$45,568.28
30	3796	WEST-021	Name 16	TR. 10	$49,245.98
31	3796	WEST-023	Name 17	TR. 17	$44,885.17
32	3796	WEST-027	Name 18	TR. 1	$46,762.84
33	3796	WEST-028	Name 19	TR. 15	$48,591.93
34
Export