Excel - Data Looping

fhigawa

New Member
Hi guys,

Need some help!

I have to read the data from File1 (1st image), and save it an array.
Then, read it File2 (2nd image), and compare the data with File1.

Like, if value in ColumnA (File1) matches w/ ColumnA(File2), have to read the B and say if its the same value and report "OK"
If data in File1 doesn`t have in File2, report - " XXXXX Not found in File2". Also If data in File2 doesn`t have in File1, report - " XXXXX Not found in File1".

Reporting it in a new Excel called report, comparing those datas.

Please, help me. Tomorrow I can post my task so far, but its in an infinite loop.. and I need help asap.

Thanks!
 

Attachments

  • 1539817706012.png
    27.9 KB · Views: 24
  • 1539817848024.png
    29.4 KB · Views: 21
Top