Macro to summarize total line items per invoice

[SaraQuinn]

Hello, I need a macro that summs the totals per invoice line items in columns H and also repeat in column H to match the total of the invoice in column F per unique coding (service/loc) under column E

 

[SaraQuinn]

MSSL Import Sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Batch		202312	H	50,043.11												Notes:
2	Invoice	IN	819436	KLSSTE	12/12/2023	29,847.35	819436	30				1/11/2024		1100	CP-COR		Correct Service/Loc to TR-SCF
3	Transaction	4050			TR-NAP	1		884.06	884.06								Summarize the total of each Service /Loc to match the invoice total
4	Transaction	4050			HN-NAP	1		662.49	662.49								One line TR-SCF total 12785.61
5	Transaction	4050			TR-NAP	1		852.02	852.02								One line HN-NAP Total 17061.74
6	Transaction	4050			HN-NAP	1		638.48	638.48
7	Transaction	4050			TR-NAP	1		869.22	869.22
8	Transaction	4050			HN-NAP	1		651.37	651.37
9	Transaction	4050			TR-NAP	1		888.81	888.81
10	Transaction	4050			HN-NAP	1		666.05	666.05
11	Transaction	4050			TR-NAP	1		892.64	892.64
12	Transaction	4050			HN-NAP	1		668.92	668.92
13	Transaction	4050			TR-NAP	1		887.5	887.5
14	Transaction	4050			HN-NAP	1		665.07	665.07
15	Transaction	4050			TR-NAP	1		840.85	840.85
16	Transaction	4050			HN-NAP	1		630.11	630.11
17	Transaction	4050			TR-NAP	1		787.11	787.11
18	Transaction	4050			HN-NAP	1		589.84	589.84
19	Transaction	4050			TR-NAP	1		827.85	827.85
20	Transaction	4050			HN-NAP	1		620.37	620.37
21	Transaction	4050			HN-NAP	1		644.79	644.79
22	Transaction	4050			TR-NAP	1		860.44	860.44
23	Transaction	4050			HN-NAP	1		660.13	660.13
24	Transaction	4050			TR-NAP	1		880.91	880.91
25	Transaction	4050			HN-NAP	1		649.94	649.94
26	Transaction	4050			TR-NAP	1		867.31	867.31
27	Transaction	4050			TR-NAP	1		819.59	819.59
28	Transaction	4050			HN-NAP	1		614.18	614.18
29	Transaction	4050			HN-NAP	1		627.45	627.45
30	Transaction	4050			TR-NAP	1		837.3	837.3
31	Transaction	4050			HN-NAP	1		600.78	600.78
32	Transaction	4050			TR-NAP	1		801.71	801.71
33	Transaction	4050			HN-NAP	1		654.18	654.18
34	Transaction	4050			TR-NAP	1		872.97	872.97
35	Transaction	4050			TR-NAP	1		864.03	864.03
36	Transaction	4050			HN-NAP	1		647.48	647.48
37	Transaction	4050			HN-NAP	1		659.56	659.56
38	Transaction	4050			TR-NAP	1		880.15	880.15
39	Transaction	4050			HN-NAP	1		620.57	620.57
40	Transaction	4050			TR-NAP	1		828.12	828.12
41	Transaction	4050			TR-NAP	1		819.15	819.15
42	Transaction	4050			HN-NAP	1		613.85	613.85
43	Invoice	IN	819437	KLSSTE	12/12/2023	18,016.99	819437	30				1/11/2024		1100	CP-COR
44	Transaction	4050			TR-NAP	1		866.27	866.27
45	Transaction	4050			HN-NAP	1		649.16	649.16
46	Transaction	4050			TR-NAP	1		848.43	848.43
47	Transaction	4050			HN-NAP	1		635.79	635.79
48	Transaction	4050			TR-NAP	1		829.12	829.12
49	Transaction	4050			HN-NAP	1		621.32	621.32
50	Transaction	4050			HN-NAP	1		634.3	634.3
51	Transaction	4050			TR-NAP	1		846.44	846.44
52	Transaction	4050			TR-NAP	1		839.86	839.86
53	Transaction	4050			HN-NAP	1		629.37	629.37
54	Transaction	4050			TR-NAP	1		878.36	878.36
55	Transaction	4050			HN-NAP	1		658.22	658.22
56	Transaction	4050			HN-NAP	1		667.19	667.19
57	Transaction	4050			TR-NAP	1		890.33	890.33
58	Transaction	4050			TR-NAP	1		883.47	883.47
59	Transaction	4050			HN-NAP	1		662.05	662.05
60	Transaction	4050			HN-NAP	1		636.57	636.57
61	Transaction	4050			TR-NAP	1		849.47	849.47
62	Transaction	4050			HN-NAP	1		605.83	605.83
63	Transaction	4050			TR-NAP	1		808.45	808.45
64	Transaction	4050			TR-NAP	1		892.48	892.48
65	Transaction	4050			HN-NAP	1		668.8	668.8
66	Transaction	4050			HN-NAP	1		649.28	649.28
67	Transaction	4050			TR-NAP	1		866.43	866.43
68	Invoice	IN	819438	KLSSTE	12/12/2023	5,683.37	819438	30				1/11/2024		1100	CP-COR
69	Transaction	4050			HN-NAP	1		1272.53	1272.53
70	Transaction	4050			TR-NAP	1		778.46	778.46
71	Transaction	4050			TR-NAP	1		688.28	688.28
72	Transaction	4050			HN-NAP	1		1125.1	1125.1
73	Transaction	4050			HN-NAP	1		1128.59	1128.59
74	Transaction	4050			TR-NAP	1		690.41	690.41
75	Invoice	IN	819457	UPDS	12/12/2023	282.73	819457	30				1/11/2024		1101	CP-COR		Summarize totals not showing negatives
76	Transaction	4049			HN-PDX	1		286.03	286.03								one line total 282.73
77	Transaction	4049			HN-PDX	1		-3.3	-3.3
78	Invoice	IN	819458	UPDS	12/12/2023	212.67	819458	30				1/11/2024		1101	CP-COR
79	Transaction	4049			HN-PDX	1		214.33	214.33
80	Transaction	4049			HN-PDX	1		-1.66	-1.66
Original Batch 1783

 

[SaraQuinn]

Here what I would like the result to look like

MSSL Import Sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Batch		202312	H	50,043.11
2	Invoice	IN	819436	KLSSTE	12/12/2023	29,847.35	819436	30				1/11/2024		1100	CP-COR
3	Transaction	4050			HN-NAP	1		12785.61	12785.61
4	Transaction	4050			TR-SCF	1		17,061.74	17061.74
5	Invoice	IN	819437	KLSSTE	12/12/2023	18,016.99	819437	30				1/11/2024		1100	CP-COR
6	Transaction	4050			HN-NAP	1		7717.88	7717.88
7	Transaction	4050			TR-SCF	1		10299.11	10299.11
8	Invoice	IN	819438	KLSSTE	12/12/2023	5,683.37	819438	30				1/11/2024		1100	CP-COR
9	Transaction	4050			HN-NAP	1		3526.22	3526.22
10	Transaction	4050			TR-SCF	1		2157.15	2157.15
11	Invoice	IN	819457	UPDS	12/12/2023	282.73	819457	30				1/11/2024		1101	CP-COR
12	Transaction	4049			HN-PDX	1		282.73	282.73
13	Invoice	IN	819458	UPDS	12/12/2023	212.67	819458	30				1/11/2024		1101	CP-COR
14	Transaction	4049			HN-PDX	1		212.67	212.67
Data After Running Macro

Cell Formulas
Range	Formula
H4	H4	=F2-H3
H12,H14	H12	=F11
I12,I14	I12	=F11