Does anyone have a neat way to compare a row of data in one sheet to a row of data in another sheet? In other words, I have two sheets (A & B) with thousands of line of data in each. There are 24 columns (24) in each sheet and the column names are identical. I want to search every row in sheet A to find the row in sheet B where the values in each column are exactly the same.
Thanks.
Bookmarks