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.