List of components needed to build project

[brad3095]

I have not used Excel in years and I have never used it for what I am asking today. I want to create a worksheet that I can enter quantities of "units" and a list of components required to build said units is returned. May not be possible, but would be really helpful for the shop floor.

For instance; I need to build (5) 12x24 units. Each unit requires (2) 24" HR's, (1) 12x24 T and (2) 12x24 side panels to assemble the unit. If anyone can point me in the right direction to get started, it will be greatly appreciated.

Thanks!

[gak67]

Something like this?
Book4.xlsx

[FDibbins]

gak has a good setup in his file 1 suggestion however, would be to put all the "lists" on 1 sheet, and give them a name range. That will make pulling the data out a bit easier/simpler

[brad3095]

Wow! This is it! I am impressed with the speed of your response. It looks complicated, but now I know which funtions(s) I need to research. Thank you so much.

Brad

[brad3095]

Thanks for the additional information. It is greatly appreciated.