Hi,
I have a workbook in which sheet 1 has few ID and name with details and sheet 2 is having list of ID and name with details .
Looking for a macro which will match the ID in sheet1 with sheet2 , if ID matches then look for the amount in column D if amount is same in both the sheets then...