VBA code to give summation value in level wise

[vinodhmmraj]

Hi All
I have this spreadsheet with parts in different levels. All level 5 part goes into level 4 and all level 4 goes into level3 and so on till Level 1. Now i need a vba code to add cost of all level 5 between any level 4 to populate it level 4 and all level 4 cost to show in level 3 (all 4 level under 3 till next 3). i have denoted in different color in the file attached. Kindly help me on this please.

Thanks in advance
Vinodh

[shg]

How about ...

	A	B	C	D	E	F	G
1	Lvl				Cost	Tot Cost
2	1	whatever	whatever	whatever		260	F2: {=IF(E2, "", IF(A3 <= A2, "", SUM(E2:INDEX(E3:$E$32, MATCH(TRUE, A3:$A$32 <= A2, 0) - 1))))}
3	2	whatever	whatever	whatever		260
4	3	whatever	whatever	whatever	12
5	3	whatever	whatever	whatever	12
6	3	whatever	whatever	whatever	12
7	3	whatever	whatever	whatever		224
8	4	whatever	whatever	whatever		0
9	5	whatever	whatever	whatever
10	4	whatever	whatever	whatever
11	4	whatever	whatever	whatever		40
12	5	whatever	whatever	whatever	10
13	5	whatever	whatever	whatever	20
14	5	whatever	whatever	whatever	10
15	4	whatever	whatever	whatever		39
16	5	whatever	whatever	whatever	15
17	5	whatever	whatever	whatever	12
18	5	whatever	whatever	whatever	12
19	4	whatever	whatever	whatever		24
20	5	whatever	whatever	whatever	12
21	5	whatever	whatever	whatever	12
22	4	whatever	whatever	whatever		110
23	5	whatever	whatever	whatever	22
24	5	whatever	whatever	whatever	22
25	5	whatever	whatever	whatever	22
26	5	whatever	whatever	whatever	22
27	5	whatever	whatever	whatever	11
28	5	whatever	whatever	whatever	11
29	4	whatever	whatever	whatever
30	4	whatever	whatever	whatever		11
31	5	whatever	whatever	whatever	11
32

[vinodhmmraj]

Hi Shg

I tried the above code but not working for my application. I have attached the file what i intended to get. also they may be cases where i may
add new row and add data .
so in that case we need to have the cost in level 1 update automatically.

Thanks
Vinodh

[vinodhmmraj]

Can anyone help me on this please