Thank you for taking the time to read my post.
I have the below code which works for comparing 2 spreadsheets and the cell data when they are aligned correctly.
The problem that I have is that a row of data can be deleted from one worksheet and not the other and this causes the formula to mismatch due to the missing row data in one worksheet.
MY Q: is there a formula that can be used to factor in when a row has been deleted and it will look for the corresponding cell like a V look up which can be used as part of the below formula?
=IF(MHL_Data!B4<>(SDB_Data!C8+0),"MHL TAB:"&MHL_Data!B4&" vs SDB TAB:"&SDB_Data!C8,"")
I have the below code which works for comparing 2 spreadsheets and the cell data when they are aligned correctly.
The problem that I have is that a row of data can be deleted from one worksheet and not the other and this causes the formula to mismatch due to the missing row data in one worksheet.
MY Q: is there a formula that can be used to factor in when a row has been deleted and it will look for the corresponding cell like a V look up which can be used as part of the below formula?
=IF(MHL_Data!B4<>(SDB_Data!C8+0),"MHL TAB:"&MHL_Data!B4&" vs SDB TAB:"&SDB_Data!C8,"")
