Different back and lay orders on same selection on excel

[konners121]

Does anyone know how it is possible to have for example

1. One Back order at the current lay price
2. One lay order at the current back price

As far as I understand there is only one cell for stake and odds on excel per selection, so I was wondering how you get around this if you want to automate back and lay orders at different prices/odds etc.

[nigelk]

You'll have to use a bit of vba, when the first bet is accepted (the status cell is showing placed), put the new order in, back/lay, odds/stake and then clear the existing "placed" command.