Terminé

Macro to Email Me When Cell Changes -- 2

Hi,

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

Compétences : Visual Basic, Excel, Architecture Logicielle, Excel Macros

en voir plus : macro email outlook 2007, excel macro move data existing cell, trigger macro cell changes particular range, excel send email if conditions met, send automatic email from excel to outlook, macro to send email from excel with attachment, macro to send email from excel using gmail, excel macro to send email automatically, automatically send emails from excel based on cell content, excel automatically send email when cell value changes, how to automatically email excel spreadsheet daily, excel vba run macro when cell value changes, send email when value changes in google spreadsheet, excel date stamp when cell changes, excel vba change cell color when value changes, google sheets timestamp when cell changes, excel macro to send email based on cell value, auto run macro when cell value changes, run macro when any cell changes, run macro when cell changes to specific value

Concernant l'employeur :
( 21 commentaires ) Leeds, United Kingdom

Nº du projet : #26372155

Décerné à:

writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(61 Commentaires)
5.5

8 freelance font une offre moyenne de $39 pour ce travail

(433 Commentaires)
7.2
mtdevil369

Hi, Greetings! ✅checked your project details :Macro to Email Me When Cell Changes -- 2 ✅Completed Time : 24 hours or your requirement deadline . I would like to work on your project and want to be discussion . I have Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(277 Commentaires)
6.8
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA developer currently at the post of Forum Expert at www.excelforum.com. I would like to provide my services for this project. I can develop a Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(152 Commentaires)
6.1
AnowarRatul

Hello sir, I have read your project details and reviewed attachment carefully and understand it clearly. I have done this type of projects before. I can solve this by maintaining 100% accuracy of your data absolutely Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(159 Commentaires)
5.8
wangdao5211

Hello! I am happy to put my bid on your project. I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with email sending using Excel formula and VBA. Everyone call me Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
3.9
Saravanangukan

I think i can able to do this work with me full endurance and enthusiasm. I can able to deliver the project on time.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
Vikpaw22

My name is vikrant. i was looking for the job it is suitable for me. i was working for [login to view URL]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0