You should first create a macro that saves an Excel file in PDF format. Anytime you run that macro, your Excel file will convert into a PDF. Therefore, any report you create in Excel can be saved as PDF with one click.