Macro to compare the data between 2 files and generate the count

Hello hemesh,

Thanks for reply.

Formula option is good but i need only a Macro. If you can add the formulas in a Macro then it will also work for me.

Thanks,
MG