Hi,
I am trying to make my own spreadsheet. I'm making progress but really stuck on how to automatically get the days races into excel. I would like to be able to use a drop down menu in excel to select a race, it then show runners, track, time, date etc. Could someone point me in the right direction on how to do this please? I have Googled but still cany figure it out! I have zero excel skills but learning as I go!
Thank you
Races into excel
That's a big job for a beginner. Try starting by storing values on BA (race, trainer, jockey, whatever), exporting them to a CSV and then paste them onto Excel in a list. That would be a start from where you can develop as you learn Excel. Takes me 2 minutes a day to do that.
-
- Posts: 22
- Joined: Wed Jan 05, 2022 8:46 pm
Hi, sorry for interrupting here, but when I use the guardian automation rule to export the stored values to the csv file, it always seems to be empty when I look after. Do I have to specify which stored values I want to export because at the moment I’m just using the store all option. Also does it also record in-play stored values?weemac wrote: ↑Thu Mar 24, 2022 4:29 pmThat's a big job for a beginner. Try starting by storing values on BA (race, trainer, jockey, whatever), exporting them to a CSV and then paste them onto Excel in a list. That would be a start from where you can develop as you learn Excel. Takes me 2 minutes a day to do that.
Any tips would be great, thanks!
if you load all the markets into Guardian and right click you can export the list to a spreadsheet.Undockedstar wrote: ↑Thu Mar 24, 2022 4:19 pmHi,
I am trying to make my own spreadsheet. I'm making progress but really stuck on how to automatically get the days races into excel. I would like to be able to use a drop down menu in excel to select a race, it then show runners, track, time, date etc. Could someone point me in the right direction on how to do this please? I have Googled but still cany figure it out! I have zero excel skills but learning as I go!
Thank you
-
- Posts: 25
- Joined: Sat Apr 10, 2021 6:30 pm
Sorry didn't notice I had replies! Thank you for the help