hi, I am a very newbie to Excel. The only thing I've learnt so far is =SUM() which is very useful for me to calculate the monthly income and expenses.
Now I'd like to create a simple invoice system. I often need to create invoice but I want to automate the process a little bit. For example, as I enter the customer name or ID in the invoice, it would then automatically fill out the billing/shipping address of that customer from my customer list
(I've created a table containing a list of my customers' information)
At the same time, I'd like to create a table of a record of my invoices, which will contain the invoice number, customer name, total amount, paid and due, and the status of the invoice i.e. pending, handling, shipped, complete etc. At any time I update a particular invoice, the list will update
as well, or if I update the information on the list, then the corresponding invoices will be updated too.
I don't want to use template....There is no simple template that would fit my needs exactly. I want to learn something..............
Bookmarks