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