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. Suggestions would be great !
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123