Excel / Access Database - Quantity Calculation Macro

-Urgent- Let us know if you are available today

I need a VBA Macro code to create a Quantity calculation function for our Bill Of Material.
The problem is rather simple, we have list of Components in a hierarchized structure, the structure is expressed with a Level column formatted like 1.1.2 or 1.2.12 etc.
We need the ability to calculate the total quantity of each child of the structure based on it’s level and parent quantity.
This means we need a CumulQty column for the level 1.x, but also a column for the CumulQty for the Level 1.x.x and 1.x.x.x

The solution can be done in Excel (VBA) , through Power Pivot or through Access.
Regardless, we need a CumulQty Column for each level to be created in our structure.


BOM example :

Level Flat Level VER_ID Qty
1 1 Vpr-1000541 1
1.2 2 Vpr-1002497 1
1.2.1 3 Vpr-1003139 4
1.2.1.1 4 Vpr-1002486 1
1.2.1.1.1 5 Vpr-1002710 1
1.2.1.1.1.1 6 Vst-1024854 1
1.2.1.1.1.2 7 Vst-1024861 2
1.2.1.1.2 8 Vpr-1001423 2
1.2.1.1.2.1 9 Vst-1024865 2
1.2.1.1.2.2 10 Vst-1026864 2
1.2.1.1.2.3 11 Vst-1039814 2
1.2.1.1.2.4 12 Vst-1024852 2
1.2.1.2 13 Vpr-1002883 1
1.2.1.2.1 14 Vpr-1002976 1
1.2.1.2.1.1 15 Vpr-1002068 2
1.2.1.2.1.1.1 16 Vst-1026866 4
1.2.1.2.1.1.2 17 Vst-1024834 4
1.2.1.2.1.1.3 18 Vst-1024877 4
1.2.1.2.1.1.4 19 Vst-1024580 1
1.2.1.2.1.2 20 Vst-1024834 4
1.2.1.2.1.3 21 Vpr-1000826 2
1.2.1.2.1.3.1 22 Vst-1024834 4
1.2.1.2.1.3.2 23 Vst-1024822 1
1.2.1.2.1.3.3 24 Vst-1026866 4
1.2.1.2.1.3.4 25 Vst-1024877 4

Best regards,
Nicolas B