Reporting Sheet Names

[sgfromny]

I have multiple tabs in a excel workbook - each with a list of parts (bill of materials) within it.. The sheet name is the Assembly name ie. Desk1, Desk2..etc. - how can I identify on one sheet all the different parts within each desk while totalling the values for common parts in the tabs, listing the common parts only once.

This is a long answer i think.
Thanks to anyone willing to answer this one!

Steve

 

[xlbo]

It would make your life faaaaaaaaaaaaaaaaar easier if you had all the parts on 1 sheet with an extra column that held the Assembly name

If you set it up that way, your reporting needs will be minimal. The way you have it now, you will either have a lot of manual formula entry or you will have to write some code

 

[SkipVought]

Ditto to xlbo, from an old manufacturing systems guy!

One List with Parent/Child or Assembly/Component...

You'll be able to navigate the entire BOM on that sheet.

Same goes if you have some kind of model effectivity. Make a column for that too.

Keep in mind that the BOM DOES NOT need to include part-specific info like Nomenclature or Type, but it DOES need to include Quantity per Next Assy, since multi-used parts usage is Next Assy specific.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}