Automatic Macro when Cell Value changes

[Steven1985]

Hi, Im new to this and also a novice with excel and would really appreciate help with my query please?

I have created a spreadsheet for work to monitor supplier performance and referrals of accounts to other areas of the business. This spreadsheet is a template to copied daily for the analysts to work.

I have in Cell B2 the date of the Alert. In cell AE2 I have the formula -today() to calculate todays date. In cell AF2 i have in the cell to monitor the Service Levels (the difference in days from Cell B2 - AE2) and the formula used in AF2 is =DATEDIF(B2, AE2, "D"). So far all this works.

What I need to do is have a macro that will run automatically when cell AF2 reaches 3 days SLA to then send an e-mail to an Analyst to promt them to chase up the referral.

Can someone please help with this? Any further information required im happy to provide. Many Thanks. Steve

 

[VoG]

Basically you would need to add the Worksheet_Calculate code to each sheet to be monitored, amending the range to be checked to suit.

 

[Steven1985]

Hi Peter,

Is there any way this can be run without opening Excel? This is a template for a daily spreadsheet. A new spreadsheet will be opened daily. None of the analysts will go back and open the previous days spreadsheet to run this macro.

Thanks

 

[VoG]

Hi. Excel must be open. You could use the Windows Task Scheduler to launch Excel. If you need help with that please start a new thread as I have no experience of doing that.