Create email alerts , pop up alerts or some time or mechanism to record changes in Excel 2010
Posted on 2013-05-19
This is somewhat of an open ended question because I simply do not know the limitations of Excel. I work with a number of very large workbooks. In many cases, the decisions we make on the marketing side of things depends on whether or not certain number are coming within a certain range. As of right now I have to pour through every worksheet to manually find performers and under performers. Is there a way to programatically send out an email when data for a certain cell falls out of range? If not can I can some other notification? Maybe a pop up, a conditional formatting trick or maybe even a summary worksheet withing a workbook that records this data. Any info ideas would be greatly appreciated.