✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
In this second installment of our Invoice Project in Excel we will use a macro VBA that will serve to save the data of the invoice in the sheet called Detail of invoices. We will also have a formula that will return the last registered invoice number which will serve to have a consecutive invoices.
Sheet Detail of invoices
In the sheet called Detail of invoices we will save the data of each invoice, which will be saved with the macro that we developed. The data that will be saved are:
Date. Date of the invoice.
Consecutive. The number of the invoice.
Invoice a. The customer to whom the invoice will be generated.
Code. Product code.
Description. The description of the product.
Quantity. The number of units sold.
Amount. The multiplication of the number of units sold by the unit price of the product.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
Негізгі бет Invoice in Excel Part 2 - VBA macro to save invoice detail and consecutive @EXCELeINFO
Пікірлер: 270