Convert PDF file to formatted Excel document

Convert PDF file to formatted Excel document


Job Description

Automating the process of taking data from a PDF file & outputting it to a formatted Excel document - most likely by using Excel VBA.

I only need a sub-set of the PDF file converted (this is highlighted in the attached PDF input document - "Input_File.pdf"), and up-to-now I have been copy-pasting this into an Excel worksheet.
The file consists of a list of names & events that the people will compete in. I need this information transposed into specific columns in the output worksheet. I have manually entered the first line of the output worksheet (Output_File.xlsx) to show the desired output.

Knowledge of Excel VBA will be necessary to do the job well.

We receive data in a number of different formats, so the right candidate can expect additional work in a similar vein.

Open Attachment