I have a single, multi-page Adobe PDF document that I need to breakdown into individual PDFs based on a spreadsheet I have. I have Acrobat Professional X, and I can do it in Acrobat one file at a time, but was wondering if it was possible to do it with macro.

Attached is a spreadsheet with the individual group names (based on last name) and the page number ranges (beginning/ending). Is it possible to have a macro extract the page ranges for each name and save each PDF automatically in the same directory as the PDF, with each PDF file named after the group name?

PDFListing.xlsx

I have looked online and found the code below. But it only works for individual page numbers and not as automated at saving the names.

Please Login or Register  to view this content.