I have a excel worksheet with 2000+ invoice numbers. I have a PDF file that has the same invoice numbers. I’m working on a automation where i need the robot to cross reference the 2000+ invoices numbers with the matching invoice numbers on the PDF file. The robot needs to go through each invoice number in the excel sheet and find the matching number in the PDF file, if the robot finds the matching number then it needs to change the color of that invoice cell to yellow and orange if there is no match.
The robot is checking that the invoice numbers from the excel worksheet match the numbers on the PDF. Any ideas would be great!