I have a "shopping list" which a user fills out. I need that information
to move to a seperate sheet only if the quantity is changed from a 0
(zero) to a 1 or higher.

For example:

Item Qty Total
Chair 0 0
Table 1 50

I need the information with regards to the table to move to a seperate
sheet. (It needs to include the name(table) quantity (1) and Total
(50))

As the chair quantity remains as 0 I do not want that information on
the seperate sheet.

Any assistance will be appreciated!


--
Anupkumar
------------------------------------------------------------------------
Anupkumar's Profile: http://www.excelforum.com/member.php...o&userid=35152
View this thread: http://www.excelforum.com/showthread...hreadid=549173