I have an excel sheet with three columns- (the employee number, e-mail id and flag).
I need the cells of the flag field to be set to one if the cells of the either the employee number or the email-id is empty. If either of the cells of employee number or the email-id contains an entry, the flag need not be set.
I need to write this in a Macro and not as a formula. Can someone help me out?
I need the cells of the flag field to be set to one if the cells of the either the employee number or the email-id is empty. If either of the cells of employee number or the email-id contains an entry, the flag need not be set.
I need to write this in a Macro and not as a formula. Can someone help me out?