bom

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

Dear All, I have a huge data base is the format as per 1st table i.e. Current dat. I want it in the format as per table 2 i.e. Desired data. You may be having Idea about Bill of Material (BOM). I want to sort the data as per Desired sequence. Logics of BOM in desired sequence: 1. Level 1...

Actually, I have a bunch of BOMs (Bills of Material) of very large, very complex machines that we make here at work. There are typically over 10,000 parts in each machine. The machine is broken down into assemblies and sub-assemblies by what we call Levels. There are typically 6 to 10 main...

Hi All, The subject line does not do justice to what i am asking for, but here is my question. I have a table in worksheet one. Column A has list of components, starting from row # 2 From column B to D, in row 1 i have the parent part numbers these components go into. Some components go into all...