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.
Bookmarks