Hi

I am trying to write a macro to do the following:

I have account number, date, charge in one excelsheet with 200
records.
In another excel sheet, I have the same columns but for 1000 accounts.

I need to pick each account number in sheet 1, compare it's data in
sheet 2,
and if data matches, I can say that it passed.
So, for each account number in sheet 1, i need to loop through all the
records in sheet 2 for comparison.
the steps are explained below.

1. Pick an account number, date and charge from sheet 1.
2. Search for that account number in sheet 2
3. If that account number is found,compare the date.
4. If date matches, chk charge
5. If charge matches, put PASS (charge should be rounded to 2 digits)
in next column.
5. If charge doesn't match, put FAIL in next column.

I'm trying to do this, but if some expert there can provide me the
solution quickly, it would be great.

Thanks and regards,
Sriram


--
sriramkanala
------------------------------------------------------------------------
sriramkanala's Profile: http://www.excelforum.com/member.php...o&userid=31367
View this thread: http://www.excelforum.com/showthread...hreadid=510578