hi all,

I need to compare two excel sheets(sheet1,sheet2) where in i have the
employee hours worked for a fortnight. One sheet is generated using an
exe file and the other is the one that has got uploaded to backend.
Need to find whether the hours worked match one to one.

For e.g

My sheet 1 would have data like this....(without the header)

0 4 8 6 8
6 0 5 3 0
8 8 8 8 0
4 4 4 2 0
8 8 8 8 0
11 11 10 9 0
0 0 0 0 0


(55 records)

Sheet 2

0 4 8 6 8
6 0 5 3 0
8 8 8 8 0
4 4 4 2 0
8 8 8 8 0
11 11 10 9 0
0 0 0 0 0
(55 records)

How do i make sure the datas that have got uploaded to db and the one
created by the exe are the same, if there is any difference it should
have an non-numeric value.

Thanks
Arun


--
daarun
------------------------------------------------------------------------
daarun's Profile: http://www.excelforum.com/member.php...o&userid=28954
View this thread: http://www.excelforum.com/showthread...hreadid=495607