How do I clear bet ref/bet time after a BACK/LAY completed?

[methodman]

In an Excel spreadsheet I am using the BACK-Tn trigger to fire a back and lay. I would like to reset the spreadsheet so that I can repeat the process if my selection criteria gets met again.
HOW DO I KNOW THAT THE LAY HAS BEEN SUCCESSFUL? Anybody know how I can identify it?

[Captain Sensible]

you could monitor the profit and loss column, depends how many runners you're backing on how complicated it gets. One runner would easy enough as the runners other than the one you've backed would show a loss but that would balance out as soon as he lay was matched

[methodman]

Thanks for the reply Captain Sensible but I am wanting to back multiple runners multiple times and I dont think the profit/loss will give a clear indication of the current position. Any other ideas?