help with Bet Angel multiple file
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i did one for 180 events for greyhounds
-
- Posts: 82
- Joined: Tue May 01, 2018 1:33 pm
I am using the spreadsheet "IXL Data Capture Multi Market" I downloaded from this forum for capturing data and always wondered how I'd create new sheets as currently there are only 12 sheets on this one. For some reason this forum wont allow me attach the spreadsheet but after seeing this post I went and created upto 60 sheets and tested it last night on the australian racing, but it didnt record any data on any of my new sheets from 13 to 60
All I did was copy existing sheets and named them the same as the original in sequence all the way upto 60 sheets, so each sheet is data, data (1), data (2) etc etc upto data (60)
Is there some VBA script I have to apply to make these work?
All I did was copy existing sheets and named them the same as the original in sequence all the way upto 60 sheets, so each sheet is data, data (1), data (2) etc etc upto data (60)
Is there some VBA script I have to apply to make these work?
-
- Posts: 82
- Joined: Tue May 01, 2018 1:33 pm
-
- Posts: 82
- Joined: Tue May 01, 2018 1:33 pm
But all the data of the race gets stored in the data & data (1) tabs, I dont even use the bet angel tabs they are just like the betfair interface for doing manual bets i think.
Currently the whole days racing is being captured on the data & data (1) tabs and its a nightmare to split them all up (well with my excel skills anyway) and what I wanted to do after reading this post was to create upto 60 tabs so I could guarentee that only 1 race would be on a tab each day which would make my life much easier.
So what I did was create upto 60 bet angel tabs using the same naming convention and the same with the data tabs.
So I have 60 bet angel tabs and 60 data tabs, but when i tested it data was only captured upto the 12th tab which is the last of the original tabs and nothing got captured on any of the newly created ones.
Currently the whole days racing is being captured on the data & data (1) tabs and its a nightmare to split them all up (well with my excel skills anyway) and what I wanted to do after reading this post was to create upto 60 tabs so I could guarentee that only 1 race would be on a tab each day which would make my life much easier.
So what I did was create upto 60 bet angel tabs using the same naming convention and the same with the data tabs.
So I have 60 bet angel tabs and 60 data tabs, but when i tested it data was only captured upto the 12th tab which is the last of the original tabs and nothing got captured on any of the newly created ones.
Captain, Bet Angel NEEDS the Excel sheets to be be Bet Angel, Bet Angel (2), Bet Angel (3), Bet Angel (4) etc etc to Bet Angel (100) or whatever you want the last sheet to be numbered.
Not Data.....
Do you understand that now
Not Data.....
Do you understand that now