vba compare data in 2 spreadsheets code example Example: excel vba How to compare two entire rows in a sheet MsgBox [and(1:1=2:2)]