Clearing bet reference

[octobergirl]

Hi,

I am running 4 workbooks to place 4 in-running lay bets on a range of horses meeting criteria. In theory 4 bets should be placed in the market on each qualifying horse

I get various amounts of bets placed into the market.

Could a bet reference on one book prevent further bet placement on the other books?

If so,a way around this?

Thnaks in advance for any help.

[alrodopial]

1. Combine the 4 workbooks into one. New coding must be done but it's worth it as using one workbook (a large one) is much more cpu efficient
2. Use a 5th workbook (or a sheet if you use the 1st solution) as a "master" one. Every time you place a bet copy its market there and before you place any other bet check if the current market exists there. Use it as a flag. Unmatched bets must also be cleared from there if you want to place any more.