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
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day
8 freelance font une offre moyenne de $39 pour ce travail
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
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
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
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
I think i can able to do this work with me full endurance and enthusiasm. I can able to deliver the project on time.
My name is vikrant. i was looking for the job it is suitable for me. i was working for [login to view URL]