Compare 2 excel files by ID number

Help StudioX
, , , , , , , ,
1

Hello everyone!

I would like the robot to compare two excel files by their ID number and mark in the second one the changes in there by filling the fields.
I have an excel like this:
image

And the new one is like this:
image

I want it to highlight the changes from one to the other, like this:
image

Can anyone help me? :slight_smile:
Thanks!

2

Hi, Use for each and filter datatable.