I have a workbook that has about four worksheets €¦

I want to create a list of items that will automatically be included on
worksheet tab 4 from Worksheet tab 1 if the quantity for the item listed on
the first worksheet has been changed from 0 to any other number (i.e. 1 or 10
etc).

I have a list of equipment with pricing on worksheet tab 1 and the list is
long. Many of the items will have quantities of zero and will not increase as
they will not be selected for the project being created. We have additional
columns for cost, extended cost, labor hours etc. If the quantity changes for
a part on any particular row, the extended cost changes from 0 to x and the
labor hours change from 0 to x. Once the project is approved, there is an
individual who must order all equipment that has a quantity greater than 0.
It would be ideal for that list to automatically be created on the worksheet
tab #4 so that this individual does not have to sort through the entire list
of equipment that could have been selected for the project (but was not). How
does one go about automatically creating this new worksheet (tab or sheet #4).

Thanks!!!

Eddie