Cross Reference
Hello. On Sheet1 I have a block of data that resides in an area from D7
thru BA5000. Each row contains at least 1 populated cell, but almost all do
NOT go thru BA.
On Sheet2, I have a revised data set within the same range. Can I cross
reference the data in Sheet1 with Sheet2 and highlight each cell in Sheet1
that does not exist in Sheet2? I need to check each row independently (ie
check row 7 in sheet1 to see if something is not in row 7 of sheet2).
Basically, 2 reports are generated at 2 different points in time. I need to
make sure that the cells on a given row on sheet1 still exist somewhere on
row 7 in sheet2.
Thanks!
|