Invoicing or Billing in Excel is a very helpful thing for people. Lots of people do not want to invest to purchase any Billing software. So, here i have made a billing/invoicing software in Excel which contains lots of features as below.
- Save the Invoice in PDF format with the Invoice Number Automatically in Drive.
- Enter the Rate including the GST Rate then the Invoice will calculate the rate without GST.
- Original Invoice, Duplicate Invoice, and Triplicate Invoice Copy Options are given at the top right corner with the Data Validation Feature.
- Amount in Words will automatically appear in the Invoice.
- Bill Format is made in A4 Size Paper.
VBA code to Save Invoice in PDF Automatically with Invoice Number.
Sub SaveActiveSheetsAsPDF()
Dim saveLocation As String
saveLocation = "d:\Invoice PDF\Invoice No " & Sheets("Invoice").Range("D6").Value
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=saveLocation, OpenAfterPublish:=No
End Sub
Tutorial Video
excellancet
Thanks
MAST
excellent
Thanks
place excel fily
how to add in excel
Ye Online hai, Excel me krne ke liye copy paste kr sakte hain
I want a educational billing software, employees attandance sheet software