bom generator

  1. A

    Creating multilevel level Bill of Materials (BOM) from table with only parent and child data

    Hi, I am trying to convert a report with BOM line data that shows the parent assembly in column A and the child component in column F (see below screenshot). All the data for the child component is contained in each row, with the parent assembly listed for each BOM line. However, the child...
  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...
    • tanujath
    • Thread
    • bom bom generator excel & formula excel bom insert rows bom multi-bom vba & excel
    • Replies: 2
    • Forum: Excel Questions
  3. K

    Convert a flat bom to an indented bom

    I'm trying to create a multilevel bom from a flat bom. The flat bom would look similar to the attached with the output indented bom also on the attached. I want to find the assemblies in columns where each part are used and create a waterfalling bom.
  4. S

    Creating Custom Product SKU and Pricing

    We manufacture products based on roughly 8 items that make up a single product. Each item has a description, cost and sale price. Our goal is to create a SKU generator and price calculator based on these different product options. A sample SKU might look like G1-A4-B9-H4-M5-J2-R6-K5 with a...

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