用两列和多个参数比较两本主要练习册

I'm writing a code to compare two rows in two different workbooks that can be located at different places among the column. The first column is usually grouped (multiple of the same value) in one section. This is why In this code I search by the first column, then pick the other identifier column and offset one at a time while both workbook sheets match each otherI'm writing a code to compare two rows in two d