Multiple sheets

[Royville]

This has probably been asked before so if it has could you please direct me to the appropriate post.
I have BA running and linked to Excel.
Sheet 1 is the normal sheet where ba links to excel. Sheet 2 monitors data from sheet 1 and is where I set various options - secs before start, stake etc. and sheet 3 is the normal results sheet.
Now sheet 4 records the odds for the next race. It does this every 20 sec's and starts 20 min's prior to race start. In the 'Auto Select Markets' tab, I have 'Wait Until Scheduled off. . .' ticked.
My problem is that when the next race loads there is only around 5 or 10 min's left befor the off, and I want to monitor the odds for about 20 min's.
So, is it possable for the next race to be loaded into another sheet and monitored there while the first race counts down, then switch to that next race after the previous one has started?
Maybe I need 3 sheets so as to load the races 20 minutes before the off (in a kind of loop).
Is this possable? and if so how do I do this?
Regards
Royville

[Royville]

Can anyone help me please?

Royville

[MarkRussell]

Hi,

You will need to have multiple pages open in Betting Assistant. Each new page has its own Quick Pick List. You can link to the same Excel Workbook from the different pages in Betting Assistant.

Regards,
Mark

[Royville]

Hi Mark,

Thanks for you help.

You can link to the same Excel Workbook from the different pages in Betting Assistant.

So will each Tab/Page in Betting Assistant need to link to its own seperate sheet in the Excel Workbook?

Regards
Royville

[MarkRussell]

Hi,

It's probably best to do it that way. Basically you need to organise the tab pages so that if you want to log the prices 20 mins before the off that there is more than 20 mins between each race in the Quick Pick Lists.

Regards,
Mark

[Royville]

Thanks Mark,

I'll give it a go.

Regards
Royville