Let's say that I add 200 football markets to Guardian. I link these to a spreadsheet, and want all markets to link to the first sheet named "Bet Angel". "Auto-bind Bet Angel sheets" isn't the correct feature, as it only binds the first market, and I have to manually bind the other 199 - pretty laborious!
I'm pretty sure there must be something I am missing. Could someone please explain how to simultaneously link all markets to the "Bet Angel" sheet? I've tried highlighting multiple markets, but haven't figured out a way to apply the selection to all.
Thankies!
Guardian - Bind Same Excel Sheet Multiple Times
Its only possible to have one market per sheets so you'd need duplicate sheets as per the 'BetAngel_Multiple' spreadsheet included in the download.
You can then tick the 'Auto-Bind' box on the Excel tab of the main Guardian Ribbon and it will bind each market to a worksheet
You can then tick the 'Auto-Bind' box on the Excel tab of the main Guardian Ribbon and it will bind each market to a worksheet
Thanks, Dallas. I use the one sheet and each time the market changes (every second or two) it just updates that one sheet. Other sheets then reference that first sheet. I use VBA, etc. along with the market ID to perform calculations on a per-market basis.
If it's not possible, then c'est la vie, but it would certainly be a time-saver if possible!
If it's not possible, then c'est la vie, but it would certainly be a time-saver if possible!
OK i see what you mean, you can do this by setting up a keyboard short cut, do this by navigating toEthanol wrote: ↑Sun Dec 22, 2019 11:13 pmThanks, Dallas. I use the one sheet and each time the market changes (every second or two) it just updates that one sheet. Other sheets then reference that first sheet. I use VBA, etc. along with the market ID to perform calculations on a per-market basis.
If it's not possible, then c'est la vie, but it would certainly be a time-saver if possible!
Settings > Edit Settings > Behaviour
Then select create new profile or edit if you already have an exsisting one.
For the Shortcut Catagory choose; Guardian
For the Shortcut action choose; Clone Excel Binding for all Selected Markets
and assign a shortcut key
Then in Guardian select the sheet for your first market and highlight all other and press the shortcut key and that will bind that same sheet to every market
