How to auto-search a PDF file based on info in an Excel file?

Question

I have a PDF file sent to me each week with tons of employee ID #s. I have an Excel file that has all of the employee ID #s in it. I usually spend hours manually searching each ID # from the Excel sheet into the PDF to make sure it does appear there as a check and balance. Too time consuming. I have tried copying and pasting the PDF file data into Excel, but this is a 67 page document and it will only paste data from the 1st page, and it's very messy and crazy to where I'd have to spend time deleting and rearranging it in order to use the formula I want to use to do the checking for me.

Is there some easier way to to auto-search the PDF file for the ID #s in my Excel sheet? Thanks.

Answer 1

Would it be possible to get the PDF as a different format? Depending upon the software that produced it, it might be able to produce a format that can be imported into Excel in a way that you can easily compare both documents. See if a csv or even a txt version is possible in the paystub application. You could then open the document in Excel, do a few quick reorganizations of data (hide or delete unwanted columns) and then change sort order so that both files are in the same sort order and you should be able to quickly go through your comparison.

Answer 2

If you can identify the Emp Id in the PDF file; what you need is someone to read the PDF file, extract the Emp ID info and write into an Excel file as an Emp ID list.



You then simply need run a VLOOKUP to compare/match the two files.........

Answer 3

PDF is a picture file you will have to use a converter to change it to an excel file