COPY / APPEND`
 

Hi,
I have an excel document with 2 sheets.

The first sheet contains an order that I wish to place, being 2 columns (A=
Product and B = Quantity).

I need a button that copies the product and quantity from every line in
sheet 1 where the quantity is 0 and appends it to sheet 2 ( which is my
sales order history table).

Any ideas ?

Thanks

Jon