I have an excel which contains invoice numbers and types “Credit Invoices” and “Sales Invoices”.
I have a folder that contains all the invoices but I need to sort them into the correct folders.
I need a robot to
- Read the excel file,
- Look into the folder, find the invoice then move it to a specific folders ie “Credit Invoices”
Can someone please help me understand how to read the excel, store that info, then tell the robot to move the files.
Thanks in advance.