I love the file and it works for the pdf's that you gave as an example. I am trying to use it for pdf's of bank statements. I have another file with macros that reconciles bank activity to GL ledger activity and marks with an x anything that reconciles leaving your reconciling items. The issue I have is we only get bank statement activity in PDF format. Your file and code would work perfectly if I could use the control text tab and place the column headings as text to search for in the pdf and it drops in all the text details on the pdf below that column heading? I am not sure if it is possible since it is searching for text and this is on the lines below the text. Any suggestions?