We have a Microsoft Excel shared workbook for our department. There's one specific column that relates to a data validation list. When I select 'yes' on it, I would like it to send an email to everyone in the department so they can take a look. Would I have to setup a macro? Thanks so much.