Vba code to extract specific data from pdf file and insert it in an excel sheet

[JEAN1972]

Hi Everyone ,

I receive a pdf file received that needs to be breakdown for specific case box use to extract tax values.

Note as per pdf sample file ,Box 40 tax base code varies depending on box 27 commodity code

Attached sample of expected results .

So far what I have tried through acrobat reader and power query but did not give the expected results .

Actually ,doing it manually which is very tedious

But so far using also a converter but still unsuccessful to extract pdf table.

Can anyone assist throught a vba code to extract the requested box data in excel format.