Forum Discussion
Extract Same Table from Multiple PDFs
I tried to modify the recorded macro to accept another PDF in table 002 with the next monthly summary table (table001 & table002 confusion). All of the files are in the same folder numbered increment...
Well, I can't check the queries as they connect to your local system, but I assume that the table in sheet "Acct 9542" represents the end result. Note that the 'Amount' column contains texts. In PQ, remove the $ sign and then set the data type to decimal number. Load to Excel and the pivot table will work.
Bingo!!!
Thanks a Bunch