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

Hello Guys,

I need help in creating a Macro which compare the Customer ID’s present in Column H of Sample1 file with Column B of both Sample1 and Sample2 files.

The Count of Sample1 file should come in Column I and the count of Sample2 file should come in Column J of Sample1 file.

After above steps macro should automatically pick the lowest value (value should be greater than 0, if value is 0 than macro should consider it as blank) from Column I and J and paste it to Column K.

For more clarification please refer the attached sample files.

In Sample1 file I had also shown that how the data should look after running the Macro.

Thanks,
MG