1. 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...
  2. P

    Look Up BOM Hierarchy using Level field

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

    Bill Of Material Forecast Based on Timing of Material Change

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

    Table formula query

    =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?
  5. C

    Vba MsgBox - Question

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

    another bill of material question

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

    vba to add col C value if col A value contains

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

    Paste Values Into Next Blank Row

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

    Resource allocation MACRO

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

    save excel file as copy to current folder VBA issue

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

    Indexing for BOM

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

    VBA: For Each wb In Workbooks - doesn't work

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

    Compare Inventory and spit out data

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

    Problem with macro for positions in SAP BOM

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

    VBA needed

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

    Bulk Discount Pricing

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

    Grouping BOM Components by Unique Column

    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...
  18. 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.
  19. J

    Summarising Multiple BOM Tables into one - best solution?

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

    VBA - Recursive Find

    Hi, 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. FG1|SA1|1 FG2|SA2|1 FG1|CO1|4 SA1|SA3|2 SA1|CO2|3...

This Week's Hot Topics

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