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

[skywalker1973]

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.

[ODPaul82]

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]

Ahhhh Cheers for that Paul, really appreciated mate.