Worksheet Change Only Run Upon Actual New Data

**djfatboyfats** · 08-27-2014, 06:13 AM

Good morning,

I'm running this code to send me an email when a value in my linked database changes which is set to auto refresh every 5 minutes, however this code will run each time the data source is refreshed and no specifically when there is new data, it could be the same data but refreshed.

Please Login or Register  to view this content.

This is what i want to happen if possible;

Example: At 10:00 my data source refreshes and I have an entry in B2 as Test 1 > Send Email
At 10:05 my data source refreshes and I have an entry in B2 as Test 1 > Don't send as already sent
At 10:10 my data source refreshes and I have an entry in B2 as Test 2 > Send Email

Thanks in advance

DJ

**Bernie Deitrick** · 08-27-2014, 11:57 AM

You need to have a storage area for values, say AB2:AC2, where you can compare the previous values to the current values. If they differ, send the mail and update the stored value, like

Please Login or Register  to view this content.

Also, the change event may not fire when the data source refreshes, but the calculate event will if you have other cells, say AB1:AC1, with links to the cells of interest:
=B2
and
=C2