I have a request is to create individual PDF files for every unique name in column A of a sheet in the attached file. I was think the macro logic would be as follows:
Worksheet = Sheet1
Header Row = Row 1 (need on each PDF report)
Data Range = A:E
Max rows per Name = 58
Look in Column A (Full Name) and for each unique name, create a PDF file with the Header along with each row of data. The folder location for the PDF files would be “C:\Users\jstriker\Documents\Alix Partners\PMO\PDF”. I need each PDF to be on a single page (since the max rows are 58 we should be good). Then after the 1st name report is created, then search for the 2nd unique name is Column A and repeat the PDF process, then repeat with names 3, 4, 5…... The attached is a test file with 2 names but the real file with have about 200 unique names. Also, could the PDF file names be customized from the Full Name value in column A and then add today’s date (John doe – 03 29 19.pdf).
The request is time sensitive and hope to have a solution ASAP. Thank you and reach out with any ?'s.