Hi all,

I need to compare two worksheets. It should be checked in such a way
that all the data in the first ROWin sheet 1 should be the same when
compared with the data in the range of sheet 2. It should not happen
that one cell in row 1 exists and the other does not. Also, the data is
not sorted and even if sorted, it would lead to no help. Can anyone
please help me on this please. I tried to use hlookup which compares
only the data in one cell.
In brief, the data in a row of sheet 1 should match with any COMPLETE
ROW in a range of sheet 2. Please help. I feel this can be done with
formulas but I just landed up in scratching my head. If done
with VB, then too, am much more than happy.
Your help is appreciated.

Thanks,
Praveen


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=526091