Q2 Cell Special Triggers

[xraymitch]

Gary,

Forgive me if it is obvious, (but I am tired) just wondered if their was a way I could use the special Q2 triggers to populate my Workbook for a Meeting with say 8 Races.

Thus Workbook1 containing 8 Sheets would have Sheet1 for Race 1, Sheet2 for Race 2, Sheet3 for Race 3 and so on, all from the same Meeting.

Or put another way, is their a value I can place in Cell Q2 for each of my Sheets in my Workbook, so that Sheet1 will load the First Race from Meeting X, Sheet2 will load the Second Race from Meeting X, Sheet3 will load the Third Race from Meeting X etc... ?

Thanks for any help you can offer.

Ray

[GaryRussell]

I'm afraid there isn't a specific trigger for this. You can do the following on each tab.

1) Use -3.1 to load all UK races
2) Use -1 to move through the markets and -8 to delete the unwanted markets. Cell J3 will contain "L" when the last market in the quick pick is selected.
3) Use -5 to go back to the first market
4) Repeat -1 until the required market is selected

It's not very elegant, but it's the only way it is possible at present.

[xraymitch]

But Gary don't you have a life !! It was only 4 minutes ago I posted that question

Seriously though, I am glad it was not obvious and my brain is still working thanks for the advice I will play with it and see what happens.

Might it be a trigger worth developing

Many thanks - now off to the pub or whatever is your thing with you !!

Ray

[xraymitch]

Sorry in the interests of accuracy I should say it was 24 minutes ago...