Solved

Create email alerts , pop up alerts or some time or mechanism to record changes in Excel 2010

Posted on 2013-05-19
5
269 Views
Last Modified: 2013-05-23
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.
0
Comment
Question by:futr_vision
  • 2
  • 2
5 Comments
 
LVL 40

Assisted Solution

by:als315
als315 earned 166 total points
ID: 39179364
You can do it from VBA macros. You can make any analysis and send mail.
You can find good samples here:
http://www.rondebruin.nl/win/section1.htm
0
 
LVL 16

Assisted Solution

by:Jerry Paladino
Jerry Paladino earned 334 total points
ID: 39180952
I would suggest using conditional formattting with the Color Bars or Icon Sets to establish ranges of values that fall into the lower and upper bounds you are looking for.  If the worksheet is large, you can filter by a cells color quickly reduce the sheet to just those values.
0
 

Author Comment

by:futr_vision
ID: 39180995
This is more a workbook with 40 worksheets.
0
 
LVL 16

Accepted Solution

by:
Jerry Paladino earned 334 total points
ID: 39181579
futr_vision,

It is difficult to make additional suggestions without a sample file.   We don't know if you are looking at one cell per worksheet on the 40 sheets or hundreds per worksheet, etc...  

If it is a single cell per worksheet you could have a summary worksheet that tests the appropriate cell on each sheet and returns a Yes/No if it outside the bounds.  Then you have a 40 cell table on a seperate sheet that summarizes your workbook.

If each worksheet is a list of data then perhaps a helper column on the far right of each sheet with a formula that indicates if that row has a value that is outside the bounds.  Then you could have a summary sheet with pivot tables that summarize the information from the helper colunm on each worksheet.
0
 

Author Closing Comment

by:futr_vision
ID: 39192187
All good answers. Nothing that completely answers my question but taken together might provide a solution.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question