Excel VBA macro for Reconciliation and Commenting

Hi All,

I have two sheet Sheet 1 with details of Account No, Security ID, Description, Transaction Code, DR/Cr, Amount, Comment

Sheet 2 having Account No, Security ID, INT

The macro needs to compare Account No, Security Id, Transaction Code and Amount then standard comment should show under comment column.

I have attached a sample excel sheet.

I know very basic VBA coding. Someone, please help me to create this macro from scratch.

Hi jeeva1989
Welcome to the Forum!!!
Your Sample File did not attach...please try again...
Oops...there it is...