How do I check values on 4 columns simultaneously on two different workbook?

[adrianlow]

Hi,
How do I check data from workbook A and compare it with workbook B?
Columns in workbook A that need to be check are AA and AE with respect to workbook B columns D and E.
I will need to check if they are having the same data then copy other values from other rows onto a new workbook. I need help with the logic and the looping on how to check on these 4 columns simultaneously.
Thank you,
Adrian