Hi,

I am creating an inventory program in excel for my job for pulling orders at a warehouse. I have completed the program for the most part, but want a summary page of all materials that need to be pulled by the warehouse project. I have attached the file for viewing purposes and so I can give an example of what I need to do. For example, in the Product-BG sheet, if i type in 300 in order size, that shows the warehouse manager that he needs to pull 3600 pieces of product, 300 of "bag 1"(refer to bag sheet), 300 of "insert 5/6D"(refer to insert sheet"), and 300 "ties and tags"(refer to ties and tag worksheet). What I would like is to learn how to get a summary of all of this info everytime I populate the order size column in product bg or product bx. So if i populate the order size column for any item in the product bg or product bx worksheet, I would like a line summary by item of what material he needs to pull.Using the previous example, if I entered 300 in the order size column for item 72 in sheet product-bg, a summary page would show up telling him all the material and quantities he will need for the order in one single sheet and not on seperate sheets. Then if I do this for another item, all the materials for that item will show up on the row below the previous product I populated.The goal is to get this on one printable page. Any help or advice would be greatly appreciated. Thanks.

http://www.mediafire.com/?hpwq1tynbdv32yd