Macro to compare two column return OK or Check.

[coolhit]

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.

[AlvaroSiza]

It would be a lot easier if you could provide a sample workbook.

[stnkynts]

How do you want to return "Check" or "OK"?

[coolhit]

HI I have attached file

On file i have two sheet as follows;

"Check Employee Hours"
"Check Hours"

I want to compare "Check Hours" against "Check Employee Hours".

On Check Hours sheet user keys in Start Time, End time and Break Time. Once times are keyed in then user will press the button on "SUNDAY"

This is where i need help with macro.

When user press the button, i want to check column "E" time aginst the sheet "check employee hours" column "G" if time matchs i want "OK" else "Check" displayed in column "E" on check hours.

Please can you help me.

Regards

[AlvaroSiza]

Not difficult. However, what you are requesting will blow through the formulas currently in place in Column E. This would mean they would be unavailable in a reuse scenario (which I presume is what you are attempting). How about putting the "OK" or "Check" in a new column, one to the right of "E"?

[thameem127]

Please explain your workbook clearly what is EFC T& A

[coolhit]

Not difficult. However, what you are requesting will blow through the formulas currently in place in Column E. This would mean they would be unavailable in a reuse scenario (which I presume is what you are attempting). How about putting the "OK" or "Check" in a new column, one to the right of "E"?

I am ok with macro over riding the formula in column "E" would prefer this

BUT

if you think its easier to put the macro on right of column "E" i dont mind this either.

[coolhit]

Hi

Please can someone help me with the macro

I am trying to write but not have any luck been try since last week.

Any help appricated.

Regards

[AndyLitch]

Hi Coolhit

try this and see if it's what you need..

Compare Macro Try.xls

[coolhit]

Hi Coolhit

try this and see if it's what you need..

Attachment 231623

Hi Andy

Thank you for helping me.

I have pressed the button there is an error. Adam A had 240 min on both sheet it should display OK but it says CHECK

Please advice.

[AndyLitch]

Compare Macro Try.xls

Found a couple of problems
1. The hours displayed on one sheet had different number formatting which was misleading
2. A direct comparison of the numbers on either worksheet didn't work because the was a .000000000000000001 difference.

Now you just need to consider the 30 min breaks