Hi all,
I haven't been on for a while (and have forgotten all I have learned from this site) primarily because I haven't been using excel much in my work.
However I have been asked a question by a colleague and need a bit of help in answering it.
My colleague has devised a timesheet with the following columns
Column a = date
column b = da
column c = time in
column d = lunch start
column e = lunch end
column f = time out
column g = hours worked
Basically he is looking for a macro that will check that lunch start is greater than time in, if not then a message box appears saying wrong value and deletes the value in lunch start column.
I have had a quick search of the site but can't find anything that relevant. Your help, as always, would be much appreciated.
Regards
Aidan
I haven't been on for a while (and have forgotten all I have learned from this site) primarily because I haven't been using excel much in my work.
However I have been asked a question by a colleague and need a bit of help in answering it.
My colleague has devised a timesheet with the following columns
Column a = date
column b = da
column c = time in
column d = lunch start
column e = lunch end
column f = time out
column g = hours worked
Basically he is looking for a macro that will check that lunch start is greater than time in, if not then a message box appears saying wrong value and deletes the value in lunch start column.
I have had a quick search of the site but can't find anything that relevant. Your help, as always, would be much appreciated.
Regards
Aidan