Macro in excel for converting forecast Child Item (BoM) to Parent Item (SKU)

Hello All,

In my process I receive forecast at BoM level for planning requirement. But at times I need to implode my requirement to SKU level for measuring accuracy, which am not able to do as the process becomes manual and data generated is error prone. Requesting help in creating a macro or VBA coding in excel which will take care of the implosion for me.

I'ts a bit urgent as I have a presentation on Thursday. So please assist.

Attached file contains BoM to SKU mapping and MKU forecast.

Am looking for VBA coding which will help me roll up BoM forecast to SKU level.

Regards,
Dev