Build data from Invoices.
 

Hello
I have made an excel workbook in excel 2000.
sheet1 = Invoice (gives warning if the stock level is lower in Products
while invoicing)
sheet2= Products (including stock levels)
sheet3= Customers
sheet4= Suppliers
sheet5= OverView (Payables, Receivebles, Revenue, Invenorty totals)

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


Sorry for double posting, as I think this is the most suitable ng to ask
this question.