Automation PDF reports to pre-determined Excel cells

[vishal.p]

Hello,

Looking to automate data entry process. I have 300+ pdf 25 page reports and we take few important numbers from each report and put them in excel table. We also exported into Access after all data entering is complete. Currently it's manually entered into excel.. page by page and it takes time and also higher chance of errors. I thought maybe if I convert into Excel and create macro and tell Excel to pick up those cells and import them in my mail data entry sheet. I tried several free software and also paid like Adobe X Pro to convert PDF to Excel and it works however each report ends up in different cells.

Attached is data entry sheet that I use to enter data from report. Report is 25 pages and I only look at pages 1,4,5,10,12,13,14,16,20 for couple numbers. Any direction would be very helpful. Please let me know if you guys need more info! Thanks!