I have a spreadsheet with a simple if statement to determine an outcome IE "OK" or "DUE". If OK nothing needs to happen but if "DUE" appears I need to send an email with regards to the date, subject and person concerned. 1 kind person has already supplied me with the code need to see if "due" appears on the sheet.
My question is, is this a logical method of approaching the issue or can some suggest an alternative possibly combing the if statement and the email stage.
I am a little rusty at excel only returning to it in the last couple of weeks after a couple of years of none development work IE data entry only. Thanks for your time and any possible alternatives
My question is, is this a logical method of approaching the issue or can some suggest an alternative possibly combing the if statement and the email stage.
I am a little rusty at excel only returning to it in the last couple of weeks after a couple of years of none development work IE data entry only. Thanks for your time and any possible alternatives