How to get Sheet 2 to populate with the same info as Bet Angel on Tab 1?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
skywalker1973
Posts: 6
Joined: Sun Feb 21, 2016 11:45 am

Hi,
Can someone help please? I have the basic BetAngel Excel sheet running that displays all the runners names, money matched, odds etc when I display the market on the 1 click screen. It displays all the raw data on Tab 1 named 'Bet Angel'. I have added, on Sheet 2, another customised set up so that I can see the info in an other way but it is just static and not populated with all the market data from Sheet 1 (Bet Angel).

How can I flick from Sheet 1 to Sheet 2 and have the same info from the market I'm on populate Sheet 2, I can't figure out how to do it. I have the Excel knowledge of a new born chimp.

All help appreciated. Thankyou for looking.
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

On the 2nd worksheet in whatever cell you want to have the data showing, type the equals sign, click onto the bet angel worksheet and click the cell that you wan't to bring the data back for.

It should look something like ='Bet Angel'!A9
skywalker1973
Posts: 6
Joined: Sun Feb 21, 2016 11:45 am

Ahhhh Cheers for that Paul, really appreciated mate.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”