Thread: Can I create an excel macro to search & extract certain information from a pdf file?

Hello,

I am new to Excel and was wondering if there is a way to create a macro for my situation.

I am recording voting decisions from a Adobe pdf file into an excel spreadsheet. I need to go through multiple pdf files and find the pages where votes have taken place. The picture attached shows a vote circled in red.

I then need to record the following information into an excel spreadsheet:
1) The number of 'yes' votes and the number of 'no' notes
2) The names of the people who voted yes and the names of the people who voted no
3) The pdf page number of the vote recorded

I would like to compile all of the information in an excel file for later use in the statistics software spss.

There are hundreds of individual votes I need to record and would love it if someone can help guide me in creating a macro for this tedious project.

Thank you!

I doubt it