Know what you mean, mucking about and missing to place a bet.
But it's only a small step from where you are to collect the odds and let Excel place the bet for you just in time? in other words running on auto?

Sorry don't ask how to do it, I know next to nothing of Excel I was just interested in what you were doing.

Good luck with it.