I have a spreadsheet (attached) that contains information from football matches. It refreshes/updates each second and is connected to third party software via COM.
I would like a macro that will send me an email when there is an increase in the Total Amount Matched (column P) for any team of 1000 or more from the previous refresh.
The email should contain in the subject line the name of the selection where the increase occurred (from column A) and the match details (the first cell for each match) and the exact amount of the increase.
The example attached contains 12 matches but the macro should have the ability to handle up to 20.
The details for each match are inserted every 10 rows, starting with A1. So, they will be in A1, A11, A21, A31, etc.
The code should be efficient and not use formulas.
Here is an example:
The first match in the spreadsheet attached is Sheff Utd v Tottenham (A1). If the Total Amount Matched for Sheff Utd increased by 2000 from the previous refresh the macro should send an email with the subject line:
Sheff Utd: Sheff Utd v Tottenham - 18:00 Match Odds
I will set up a specific gmail email account to send the emails from.
If you have any questions please let me know