I have setup remote temp readings that update in excel every second. When the internal temp reading in Col C equals the external temp in col E, the corresponding row in col G will highlight as a match and display the property and room where the match exists. I would like to know if it is possible for VBA code to be applied to do the following: Scan/loop Column G and if the row is not blank to take the output and send via telegram as an alert system. As the temperature moves a lot I would only like to be alerted once every hour but would prefer to leave the possibility of having this as a variable setting eg. every 5,10,15.20 mins linked to the excel document should I wish to change it.
Must be flexible if I was to add additional columns so that the overall code is not interrupted.
Bu iş için 16 freelancer ortalamada £27/saat teklif veriyor
Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. All clients call me "Prince of Excel". I promise I Daha Fazla
Hi, i am ACCA member with 8 years of experience in finance and accounts. I am good with MS Office please let me know for more details. Thank you