Creating a used parts list?

Hi all,

I am currently building a spreadsheet at work and would like to know if a certain function is available.

I have a number of colmns such as product description, part no, quantity, net cost etc... The user has to enter the quantity and the spreadsheet calculates a total cost for that item.

I would like to set up a second sheet that will automatically build a parts list when the user enters a quantity. Is this possible? I would like the parts list to reference back to certain cells such as part number and cost.

My Office currently has to print out the whole list regardless of whether or not an item is being used which I feel is a big waste.

I hope I have explained myself clearly and I would be very grateful if anyone could advise me about how to set up this formula.

Thanks for the tip but its not quite what I am trying to do.

I would like to have a second sheet that will build up a list of part numbers and quantities automatically if a quantity is entered in the correct row of the front sheet. This will then autofill a table with part numbers

Sounds like a good use for Auto Filter. Go to Data|Filter and select Auto Filter. All of the columns should then have an Arrow on the top Row of Data. Select the arrow in the Qty field and Select "Custom". Then set that up to values greater than 0. It will then hide all of the rows that have 0 in the quantity field.
You can then either copy the remaining cells to another sheet or select the remaining cells and use "Print Selection".

That does look like it does the exact thing I want! I just don't have the ability to set it up properly.

Thanks for the help!