Hi ,
Unfortently m this is the third time that I post and I get no answer , Can someone please advice me on a how a workflow would look like . I have two excel files that I want to compare one row from the first excel file with the same row but in the other excel file (to find similarties and differences) and give message box for both?? How a workflow would look like?
I found how to compare two different sheets in one excel file but this is different because its two different excel files .
Regarding the two differnet sheets, I have found this example - you can follow it
Regarding your point about creating datatable, why would i do that? I just want the robot to compare two rows in both excel files and to color the different entry in one excel file .