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...
Gave it a shot which ended up with no values transferred into the pivot table which included the options provided: the obvious being sum of Amount. Acct 9542 column A should be the header and the corresponding values aligned in the date row (Sheets2). Not sure how to handle the blank cells that are linked to the beginning and ending data.
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
