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