Hi

I need to write a macro to compare column between two sheet and return "Check" or "OK".

MACRO ISSUE.jpg

I have a button on sheet 3, when i press it i would like to check value in cell E4 and match it against sheet 2 cell G7. If it match return ok else check.

one this loop is done then go done 1 cell and do the same untill no more entry found to compare.

I have attache image.

Please can someone help me.