I have made a worksheet containing a a large number of products (product
list) and want to automatically populate another worksheet (order sheet)when
the quantity column has a number.
for example:
sheet 1
a:1 a:2 a:3
xyz 2 $9.95

so that when a:2 (the quantity column) =1, the cooresponding info goes to
the order sheet. Any ideas would be appreciated
--
regards,

Tom