Excel VBA export mulitple rows to PDF

[jannerman]

Dear All,
I have an excel spreadsheet that by selecting one cell corresponding to a row formats the data , by passing it to another spreadsheet page, and then converts to pdf, giving the user the option where to save the pdf.

What I now need to do is allow the user to select multiple cells (that contain all relevant data in the row) and then format the data via the
additional page and convert to pdf i.e. by having all the entries one after another.

I've tried looping and searched the internet with no success, in access this is simply achieved by using a query in excel it's looking impossible :-(

Any ideas or pointers would be appreciated.

[jannerman]

PROTO.xlsm

File is attached

[jannerman]

Okay shall I rephrase the question ? Is it possible to format the pdf before converting i.e. put every cell in a selected row descending instead of horizontal? I find the description of this site very misleading