I know there is various topics regarding this, but I can’t find the solution that helps me.
I get an excel file that I need to sort out certain rows from and create a new excel file which will go to manual control. I have solved this by first creating a data table and several If statements to control if data in the row is going to manual control or not.
My issue is that I don’t get the robot to “paste” the entire row that is going to manual control into a new data table and further an excel workbook. All of the rows going to “Else” have to go into a new workbook to manual control.