Attached is a sample excel spread sheet. If anybody can post a work flow or some suggestions that would be greattest book.xlsx (10.0 KB)
Im trying to build a Robot that will read the invoices numbers from column E of sheet two and match them with the invoice numbers from sheet 1 in column A. If the invoice numbers match then the robot needs to check that the company names also match.
If the invoice numbers are matched then check the to see if the company names match. If the companies names and invoice numbers match then fill the cells yellow and add a Y in the match column of sheet two.