Printing external PDF files based on user input

Hi everyone,

I have a sheet with two cell ranges for user input: C9:C28 ("Area Column"), which is used for inputing an area code such as AA, BB etc, and E9:E28 ("Quantity Column"), which is used for inputting a quantity.

Elsewhere on the same sheet, I have a VBA-generated list of all files within a specific directory - eg. C:\Users\ABC\MapsAA.pdf. All files are in PDF format and saved in a single directory.

If a user inputs AA into cell C9 and 3 into cell E9, then clicks on a "Print Maps" button, this should cause the user's default printer to print 3 copies of C:\Users\ABC\MapsAA.pdf. The user can input up to 20 area codes into C9:C28 and corresponding quantities into E9:E28 and print varying numbers of copies of the required maps.

Can anyone help with this?

Many thanks in advance.