Saving range of cells in a PDF format using a button on excel worksheet

Hi guys,

I am currently using an excel worksheet to generate a quote for my clients. And I have a 'PRINT' button the the worksheet that enables me to print out a specific range of cells in the worksheet (QUOTE).

Now, I am wondering if It is possible to create another button 'QUOTE' which will enable me to save the range of cells in the worksheet in a PDF format and store the copy in a folder named 'CUSTOMER QUOTE'. And also generate quote number for each qutoe file?

Please see attahed the excel sample file below.

Any idea or suggestion?

Thanks,