Simple VBA and Macros are used to create the automation. Simple Invoice can be used for any works but the concept of the invoice is same.

Copy the below one for Save as pdf VBA :

Sub saveinvoice()
Dim saverng As Range
Dim pdfname As String
Dim path As String

set saverng = Range(“”)
pdfname = Range(“”) & “_” & Range(“”)
path = “”
saverng.ExportAsFixedFormat xlTypePDF, Filename:=path & pdfname


End Sub