Excel 2010 - Help with Ordering parts workbook

[okie76]

Hello,

I am trying to find out if what I am wanting to do is possible, and if it is how to accomplish it. I have attached a sample workbook to help with explaining myself.

Example Order.xlsx

Sheet 1 in the workbook (Lablled Materials Order) is a list of parts that a user would use to place an order. It's columnes are as follows:
Product part Number - Product Description - Unit of Measure - Order Instructions - Requested Quantity - Part Price - Order Price
Under each columne is information for the parts we carry.

The user would then look through the list and find the part they need then enter in how many they need in the "Requested Quantity" field. All the other fields are already filled out for them.

Sheet 2 in the workbook (Labelled Order Summary) is a copy of the headers from sheet 1, but with no data below the columnes.

What I am trying to figure out is this. If a user goes to tab 1 and types in that they want to order 200 of part number 100-1005 (Screw 5) and also 500 of part number 100-1091 (Bolt 8) they would type in the appropriate quantity in the "Quantity Requested" fields, save the workbook and then email it to me. When I receive the workbook I would click on tab 2 (Order Summary) and there would be only a list of the parts they needed (the order for 200 Screw 5's and 500 Bolt 8's). Is there some kind of function that I could put into cells on the order summary to make this work?

In actuality the list is about 650 parts long and some orders range from 5 different parts to 100 different parts. Currently I am either sorting and copying, or just creating a pivot table depending on the number of different parts ordered. These methods work fine but are time comsuming so I was hoping that a list on tab 2 that somehow fills outself out as described in the preceeding paragraph is possible?

Any help in this is greatly appreciated.

[a31185]

here you go

Example order.xlsx(Solved)



Cpearson helped

[okie76]

Outstanding !

Thanks for your help. This will help me so much.

[a31185]

Thanks for the feedback. You can use the star button.