save invoice data.

T

tim

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Build data from Invoices. 0
Data Validation to exclude blank cells 6
How to merge a excel data in a word file with page breaks 1
I have Invoice 1 and2 I need to post to 1 and print iems on 2 2
passing dates in a conditional sum(if) 2
Formula Help 3
how do i set up my own invoice and save to use whenever 1
Double SUMPROD 11

Top