bom

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...

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...

Hi all, 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...

Hi All, 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?

Hi guys 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...

Hi guys, 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...

Hi, 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...

Hi, 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 Statement: 2 Sheets 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 wb.Activate If Left(wb.Sheets(1).name, 4) <> "BOM." Then wb.Close SaveChanges:=False ElseIf Left(wb.Sheets(1).name...

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...

Hello, 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: <tbody> .1 ..2 ...3 ....4 ....4 .....5 ....4 ...3 ....4 ...3 ...3 ..2 ..2 .1 ..2 ...3 ..2 ...3 ..2...

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...

Hi all, 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. Example 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: <tbody> Component Part Number C1 11111111 C2 11111111 R1 22222222 R2 22222222 R3 33333333 U1 44444444 U2 44444444 </tbody> 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.

G'day folks, 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...