Multi level BOM

**neorez** · 02-23-2010, 08:42 AM

Dear All,
I have already started with this thread

http://www.excelforum.com/excel-gene...-material.html

And we realized that it is better create it with VBA codes because it is complicated.
It’s a multi product bill of material that will help me to calculate some properties of my recipe, such as pigment %, solid %, cost price…
What I need is a kind of form that I can use to enter:
Raw material: ready to use material with fixed price and solid content.
Assembly: it is an assembly item with a formula that I must enter and that may include items and assemblies.(here is the problem: assembly in assembly in assembly..)
So, I should start by a form in which I can enter raw materials (item list sheet)
Than another form to enter defined assemblies (formulas sheet)
Than a display page (sheet detailed formulas) which will disintegrate the assembly and make a raw materials formula that I can view and analyze.

NB; the attached file is the result of the previous thread

**tony h** · 02-23-2010, 11:53 AM

Neorez,

I have done this in Excel but it is a long and complicated process. Especially when you consider all the things you are likely to want to do in the future. I would make a suggestion that Access would be a better route for you. You will probably find good sample BoM databases for Access.

Regards