Save selected print area as a pdf file using the text from a specific cells as the file na

Hi,

I use Excel 2010 on Windows 10

I have a sheet that I use for invoices.
I can print the selected print area directly to a pdf using windows 10 via printer dialogue, and then manually type in a location and file name.

I would like to have a macro to print the print area to the pdf file and pick the Invoice number from L6, the customer name from E13 and the date from L7 and combine this into one cell so I can copy and paste it to the file name for the pdf? ...or better still populate the file name and save the file to a specified folder.

Any help of suggestion would be greatly appreciated.

Hi,
I have decided to use your macros, thank you.
Can you tell me how I can change the location the file is saved to please?
There is also a problem with the footer, it only displays " 1 of " when it should be " 1 of 2 "
Really appreciate your help.