Is this a follow-on to your previous post? I didn't realize it would
have to run continuously throughout the day. If that's the case you'd
need to set up the Timer function inside a Do Loop structure, along
with Calculate commands that allow the spreadsheet to update.
Additionally you will likely need code that triggers the update event.