Excel Automated 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.

Download Example

  1. February 3, 2016 at 11:14 pm

    hello sir,
    How do I put the invoice number in the textbox
    Sheets (“Invoice”). Range (“F3”). Formula = “= today ()”

    thank you

    • netmerkez
      February 4, 2016 at 10:51 am

      TextBox1.Value = Date
      TextBox1.Value = VBA.Format(Date, “dd.mm.yyyy”)

  2. February 4, 2016 at 2:33 pm

    Thank you

  3. Sam
    September 30, 2016 at 5:30 am

    Broken link

    • netmerkez
      September 30, 2016 at 4:40 pm

      I updated links today

      • Sam
        October 1, 2016 at 3:56 am

        Thank you

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: