Hello,
Is there a way in VBA Excel one full line to compare with each other? In sheet1 A1:H1 to A2500:H2500 has information, on sheet2 A1:H1 to A10000:H10000 has other information. I need to do the following thing, line A1:H1 on Sheet1 to compare it to each row of sheet2, if in sheet2 row is found, whose cells contain the same information as in A1:H1 on Sheet1 to earn value I1, if there is no row with the same information, I1 is empty, the same should be repeated with the other 2499 rows.
Thanks in advance for the help rendered by you.