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:
SALES ORDER NO. ITEM NUMBER QTY SHIP DATE
100 KIT-1 10 9/31/2021
I am trying to come up with a method of looking up the BOM structure below, using the level column, to replicate the manual output i have created in the column 'IDEAL'.
The logic here is
1) If 'ISCONF' = 'N' then it remains 'N'
2) If 'IsConf' is 'Y' then look up at its parent, which...
I am looking for help regarding forecasting future material requirement from finished goods forecast.
I have this set up currently in excel with a few index and sumproduct formulas.
However the material code within the finished goods can change depending on promotion etc, at various...
=IFERROR(IF(INDEX(AIMS[NDC BOM Status],MATCH([WMS Order ID],AIMS[[#All ],[BOM Order'#]],0))=0," ",INDEX(AIMS[NDC BOM Status],MATCH([WMS Order ID],AIMS[[#All ],[BOM Order'#]],0)))," ")
What does the #All do?
I am using the below code to import a specific range of data from another spreadsheet into my current workbook I have open. The below code works perfectly.
However, what I am trying to achieve is to amend the code so that my current Msg box presents the following:
Instead of simply...
so i got some great help on a bill of material question a month ago. now that i have been running the new system, the bills of materials are not set up traditionally. Usually the whole bill is exploded with all levels. If i have a bunch of bills in a query that are not exploded in levels, how...
i am trying to write a vba to add values of col c (Weight) if the value in column a starts with a "W" and numbers after the "X" is less than 30 then add them all up and put the sum in cell H2(under Light). I've been working on this for a few days and cant quite figure it out, the...
I have a workbook with multiple sheets where I'm trying to copy rows where the value in column C > 0. I then want to paste these rows into a another sheet, called BoM. I'm ignoring the BoM sheet, along with a sheet called summary, and another sheet called Packet Storage.
I'm got my code...
I am looking for help on Resource allocation MACRO. Below is the detail and small MACRO someone helped me with. Any help would be appreciated. Thanks
Sheet 'Data file' contains column EA as item # corresponding to Summary tab Col C item#
Data file Column EG, EH, EI...
Hi, I wonder if anyone could help me please.
I have a code below which saves the excel file as a copy to its current location and renames the file 'customer copy'
This works fine the first time, but when a file with the same name exists in the current location and I chose the option 'No' or...
I am having trouble indexing a Bill of Materials (BOM) to eliminate redundancies. Within the BOM, multiple assemblies use the same parts or components. I am trying to create a new sheet to consolidate/organize a parts list without having to use the VLOOKUP function. I know this may be more...
I have a problem with "For Each wb In Workbooks". I want to close all workbooks which haven't met certain condition.
Dim wb As Workbook
For Each wb In Workbooks
If Left(wb.Sheets(1).name, 4) <> "BOM." Then
I have 2 workbooks that I will copy paste into a third (Macro-enabled) sheet for comparisons. Each contains the week/months inventory. Excel examples at the end
There are 15 columns with column A being the key (computer name). I want to take February's inventory and compare it to January's...
I am looking for macro which is able to exchange levels I have in BOM (downloaded to excel). Do you know easy way how to do it?
Oryginaly I have:
Please allow me to create a new thread, I think I overcomplicated the original.
I have a spreadsheet with 4 sheets within it. 1-Coversheet,2-Original BoM,3-New BoM, 4-Dashboard
The user will enter some information on the Coversheet, then copy and paste some table information into both the...
I’m currently working on a generic pricing template, where the End user is able to specify the unit cost of an item, the number of units that qualify for a bulk purchase discount and the discount rate at each of these bulk purchase intervals.
This is an example of the table...
I'm looking for a way to group BOM components for an electronics BOM. Currently my program outputs a CSV table like this for example:
I would like the...
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.
So I am looking for multiple/best solution(s) to summarise/consolidate multiple tables into one. These tables are Bill of Materials (BOM's), on each worksheet will be a table summarising the materials required for each product assembly. The tables are made up of Part Numbers...
I adapted that code from the Excel help example for the Find function and from a guy from a forum somewhere.
I want to transform that kind of BOM to a multi level BOM.
'This is from a guy looking for the same thing on another forum.