Bill of Material - Structure

joeal29

New Member
Joined
May 14, 2009
Messages
1
Trying to see if I can get some help on this. I have a 3 columns of data. A Parent that begins with FG_ a Child and Qty needed of that child to make the parent part. A Child could be a parent part in a different row and so on. I need to calculate the required Child Qty to FG_ parent, taking into account that a Child in one row could be a Parent in a different row. Example, the FG_Bike needs 116 bearing, since each link requires 2 bearings and 58 links are required to make one chain and one chain is need for FG_Bike.

Current Structure

Parent...............Child...........Qty
FG_Bike..............Frame..........1
Frame................Tubes..........7
FG_Bike..............Brakes.........2
Brakes................Brake Pad....2
FG_Bike..............Chain......... 1
Chain ................Links..........58
Links..................Bearing.........2

OUTPUT -------
Parent---------New Child---Qty at Lowest level
FG_Bike.............Frame...........1
FG_Bike.............Brakes...........2
FG_Bike.............Brake pad......4
FG_Bike.............Tubes...........7
FG_Bike..............Chain..........1
FG_Bike..............Links...........58
FG_Bike..............Bearings.......116
 

Forum statistics

Threads
1,081,560
Messages
5,359,604
Members
400,538
Latest member
leon_oscar

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top