Forum Discussion
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.
