While a formula might calculate values, a macro can calculate, format, copy data to another sheet, send an email, and create a chart all in one go. Therefore, switching becomes obvious once you ...