excel bom

  1. R

    Updating Parent part system to all child parts

    I have a table that is an extract from a Bill of Materials. I have columns A (Identifier) and B (Parent Identifier) already calculated. Currently, under column D (Part System), only the cells against the main BOM Module has a part system. I want to update this Part System to all the cells that...
  2. T

    Explode BOM lines in Excel to understand sales data by ship date

    Hi All, I am having a hard time exploding BOMs into BOM lines to explode my data by Ship date. Let me show an example below of what I am looking to do: Table 1 SALES ORDER NO. ITEM NUMBER QTY SHIP DATE 100 KIT-1 10 9/31/2021 200...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top