Multiple Bets at Different Odds and Stakes on Same Runner

[tees]

Hi,

I have a spreadsheet with a bunch of macros. When I fire a macro I have data in 12 rows and 4 columns (48 cells). Each row has the following data:

Runner
Back or Lay
Odds
Stake

An example of a few of rows:

Nadal Back 1.50 £50
Nadal Back 1.51 £60
Nadal Lay 1.49 £100
Lopez Back 3.05 £25
etc, etc,

So altogether there are 12 bets.

What I want to do is fire these bets into Bet Angel all at the same time every time I fire a macro. If I fire another macro, I want all my previous bets cancelled and the 12 new ones fired into the market.

I've had a look and play around with some of the various Bet Angel Excel sheets that are available, but I can't work out how to do this. My VBA skills are pretty feeble.

Is there any way of doing this?

Any help at all would be really appreciated.

Thanks.

/dave

[tees]

Hi,

Thanks for looking in again.

I'm wondering if I should create 12 different worksheets with the same runners on each of them? If so, how could this be done? I've tried copying and pasting but it doesn't seem to work.

Any direction/comment at all would be appreciated.

Thanks again.

/dave

[Wyndon]

Could you use a lookup table to fire the bets required at the different prices?

[tees]

Wyndon,

Thanks for your suggestion. I'll have a think on how to make that work.

Cheers.