How to extract data from PDF file to multiple fields in excel spreadsheet?


I am having a excel file in which I want to extract data from a PDF files and want that spreadsheet to get updated whenever a new file is saved in PDF file folder.


So, my main concern is that I am having a macro enabled excel file with which we makes invoice and after printing invoice it gets saved as PDF. Now I want data of that PDF files get entered into the excel spreadsheet automatically. 


I am attaching link of excel file I hope somebody will help.  



1 Reply


Perhaps Power Query works, but it depends on which Excel platform/version you are and how PDF files are structured.