I need an Excel web query/macro that does the following:
- extracts data from the attached web page
- inserts it into a sheet in an Excel document
- runs every 5 minutes
- sends out email (other notification) alerts for when certain conditions are satisfied (including when there has been a failure to update, or some software glitch)
Preferably this would be done in OS, but we can accommodate Windows also.
NB - if the web query is done in PC - the website that has the data can only handle Chrome and Safari browsers.
This is a reworking of a previous job -apologies to previous applicants - have decided that this should be sufficient.