Please Advice ! How to compare (to find similarties and differences) in two different rows in two different excel files


#1

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 .

please Advice !!
Regards


#2

@Assem_Samali

did you try creating datatable for each excel sheet and compare them

I found how to compare two different sheets in one excel file but this is different because its two different excel files .

how did you solve this…?

thanks


#3

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 .


#4

Hi will u explain me how to compare two Different Sheets in one excel and store them into another excel sheet??


#5

comparedt.xaml (16.8 KB)

Try this…