Generate a list from other lists

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!

Hello dixiechick11,

Welcome to the Forum!

To provide you with a VBA solution, you would need to post workbook. The location of these tables and columns they use are critical to creating a VBA solution for you. If you are using Excel 2007, you should also post another copy of the workbook in Excel 2003 format. This will ensure just about everyone can review your workbook. Be sure to remove or change any information that is proprietery or confidential before posting your workbook.

Sincerely,
Leith Ross