Create a part # list

[MichaelWayne_71]

There is probably a pretty simple solution to my question, but I can't figure it out to save my life.

I am trying to create a part list if a particular row has a value above "0"(zero).

e.g.
row 20 has separete columns for quantity, price, part #, and description.
If I put a 1 next to the item that I want to order, I want that to show up on another sheet so that I can have a list of just part #'s and descriptions of the items that I need to order. They need to be put below each next row. How do I have a cell look through a list of ordered items and put the next one right below it in the next row?

Let me know if I'm not explaining this correctly.

Thanks in advance!!!

 

[Joe Was]

This may help see page 2, bottom!

http://www.mrexcel.com/board2/viewtopic.php?t=7179