Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cross reference | New Users to Excel | |||
Cross reference | Excel Discussion (Misc queries) | |||
cross reference two | New Users to Excel | |||
Cross Reference | Excel Worksheet Functions | |||
Cross reference? | Excel Programming |