save invoice data.
 

Hello
I have made an excel workbook in excel 2000.
sheet1 = Invoice
sheet2= Products
sheet3= Customers
sheet4= Suppliers
sheet5= OverView


I have been able to make the invoice getting products, customer info via
data validation "list" and "Vlookup".

The question is how to save an invoice ecah time so I can get total products
(update product quantity remaning) sold and customer account balance.

I know it is not a clear question but any idea or link for a start would be
appriciated.

regards