T
tim
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.
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.