Not sure if I'm posting this in the right place, so please forgive and reroute if necessary.

I'm trying to use a list of terms (currently residing in an Excel column) to generate a list of page numbers on which each term appears in a large PDF or collection of PDFs. In other words, I want to search a PDF for term A and in the next cell return a series of page numbers where term A appears. Then I want to move on to term B, etc.

I created an index of the PDF, which now exists as a PDX file. When I export the PDX file to CSV, I get a breakdown of each instance within the PDF where term A appears. But I would have to execute this task manually 500 times if I want to search for each term in the list and then I have to combine the page numbers into a series for each term.

How can I automate this?

Many thanks,