I have an excel file (File 1) where i use data for the robot to go through a lot of costumers, and a robot inserting values into a web browser. I use the “for each row” activity for that. The robot inserts the values into a web browser where i receive a batch number, which i insert into a new excel file for each costumer(File 2). Within this “for each row” activity, i want to insert the batch number from file 2 into a column in file 1. It has to correspond with the right column in file 1.
Can someone help me out?