Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Costed Multi Level BOM
I have an file (in excel/access) which states are parent part number (col A),
level (col B), children part number(col C), and qty (col E) for parts manufactured within my facility. I have a seperate table which summarizes all the labor $ associated with the different children and parent part numbers. I am having trouble rolling up the cost of all children into the parent part numbers in some form of automated step (as I am dealing with ~10000 assemblies at various BOM levels). -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Costed Multi Level BOM
Rob, I am curious; did you ever find a solutio to your problem? I am facing
a very similar problem with rolling up data for a Work Break Down Structure. If you found a logical way to tackle this problem, would you please share with me? Thanks. Sherry "RobN via OfficeKB.com" wrote: I have an file (in excel/access) which states are parent part number (col A), level (col B), children part number(col C), and qty (col E) for parts manufactured within my facility. I have a seperate table which summarizes all the labor $ associated with the different children and parent part numbers. I am having trouble rolling up the cost of all children into the parent part numbers in some form of automated step (as I am dealing with ~10000 assemblies at various BOM levels). -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-Level Category Gridlines | Charts and Charting in Excel | |||
Multi-Level Subtotals | Excel Discussion (Misc queries) | |||
multi level worksheets | Excel Discussion (Misc queries) | |||
Multi Level Subtotals and SP2 | Excel Worksheet Functions | |||
Multi-level passwords | Excel Discussion (Misc queries) |