I have 2 worksheets in the same workbook, Sheet1 and Sheet2. Both sheets have the same number of columns, 31 columns and about 100 rows.
Both sheets have the same column values
Example:
<CODE>
colA Date
colB Prj Name
colC Proj owner
colD project status
etc... all the way to 31 columns of data
</CODE>I need to see if the rows in sheet 1 match the rows in sheet 2. The entire row, I've looked many places and all of them are matching cell to cell, I need to match the entire ROW.
For example:
Look at row 10 in sheet1 and go through all rows in sheet 2 if there is a match, do nothing. If there is not a match highlight that row in sheet1 to indicate there is no match for this in Sheet2.
Both sheets have the same column values
Example:
<CODE>
colA Date
colB Prj Name
colC Proj owner
colD project status
etc... all the way to 31 columns of data
</CODE>I need to see if the rows in sheet 1 match the rows in sheet 2. The entire row, I've looked many places and all of them are matching cell to cell, I need to match the entire ROW.
For example:
Look at row 10 in sheet1 and go through all rows in sheet 2 if there is a match, do nothing. If there is not a match highlight that row in sheet1 to indicate there is no match for this in Sheet2.