Excel Automated Invoice
EXCEL AUTOMATED MULTIFUNCTIONAL INVOICE
Today’s date is added automatically to date cell.Invoice number is automatically added (number is increased one) to number’s cell after the prepared invoice is recorded.
When a product is selected from the drop-down lists in sheet’s cells between A17-A33, Excel automatically fills the selected product’s info into concerned cells (unit price ,unit tax).
When a customer is selected from the drop-down list in A10 cell, Excel automatically fills the customer info into concerned cells. This info :
– Customer’s name and address,
– Customer’s company name.
– Customer’s Id,
Product prices and the grand total is calculated by formulas and grand total is converted to text.
Invoices can be saved to the selected worksheet from the userform. The wanted value can be searched in the recorded data by other userform.