Thread: Cross Reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_6_] Steph[_6_] is offline
external usenet poster
 
Posts: 92
Default 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!