Hi,
Request support for breaking up the Models at part level BoM.
I need to understand the way in which I can insert BoM of a particular Model and calculate respective quantities of the part level BoM items as per the Model Qty.
In attached file there are 2 sheets: BoQ & Disp. Detail.
Disp Details sheet contain Model Level Data.
BoQ sheet contains break up of each such Model.
For each, how is that I can create a Macro to :
1) Insert rows below the model code.
2) Include the parts relevant to the model code.
3) Calculate respective quantities of part codes that shall appear below the model as per standard BoM.
An instance of intended out put is included in 3rd sheet "Example"
Thanks for all your support & help.
Regards,
Upendra.
Request support for breaking up the Models at part level BoM.
I need to understand the way in which I can insert BoM of a particular Model and calculate respective quantities of the part level BoM items as per the Model Qty.
In attached file there are 2 sheets: BoQ & Disp. Detail.
Disp Details sheet contain Model Level Data.
BoQ sheet contains break up of each such Model.
For each, how is that I can create a Macro to :
1) Insert rows below the model code.
2) Include the parts relevant to the model code.
3) Calculate respective quantities of part codes that shall appear below the model as per standard BoM.
An instance of intended out put is included in 3rd sheet "Example"
Thanks for all your support & help.
Regards,
Upendra.