I have 2 folders with Excel files 1. Downloaded_RKIV_Reports 2. ModifiedReports
For each file in the 1st Folder I have to read the data and paste into the file in the 2nd Folder.
The condition is the Robot has to pick the correct file in the 2nd folder.
For example : If the file name from the 1st folder is SEP2016_BPO_RK, the robot has to pick the Modified_SEP2016_BPO
The matching criteria for this scenario is BPO.
Can it be achievable, if yes please guide me through.
Much appreciated for your kind help in advance.