Removing duplicates by comparing two excels

Help
3

@Shivaraju Another approach is like that …

image
image342×568 12.9 KB

  1. Get 2 Datatables as Yogesh said.
  2. Merge that 2 Datatables
  3. Remove Duplicate Rows
  4. Write your new Datatable to an excel file with Write Range.

Let us know which ways work better to you or if you have any questions,