Can anyone tell me if there is a way to solve this problem?:

I have several lists in multiple sheets within a workbook. The lists are of specific materials, their prices, and quantities needed. Many of the quantities needed are "0" if they are not needed.

I would like to generate a new list in a separate sheet that contains the non-zero quantity items from the other lists.

Is there some VB code that would analyze the lists and return only the items that have a positive integer under the "quantity needed" column into a new and separate list in another page.

I am basically trying to generate a basic bill of materials for a certain project.
I'd like to be able to click a button and have a list of neede materials appear in a certain place.

Thanks for any help!