Hi
I am not sure what VBA formula is the best to use for the case below:
Column L is First name
Column M is Last name
Column N is Dept
I need to look for a specific full name, if they match, then the cell next to the name in column N will change to 'Unit'. If they don't match then nothing will be changed. Please could anyone help? Thanks.
I am not sure what VBA formula is the best to use for the case below:
Column L is First name
Column M is Last name
Column N is Dept
I need to look for a specific full name, if they match, then the cell next to the name in column N will change to 'Unit'. If they don't match then nothing will be changed. Please could anyone help? Thanks.