I hope this is the right part of the forum to ask, but I must apologise
in advance if the solution is rather obvious.

Anyway, I'm rather new to Excel, but am using the coding relatively
easily and know a fair bit. But my one problem is this:

I'm creating a spreadsheet that details cricket matches and then works
out statistics (averages, strike rates etc) automatically for
individual matches or series. I know there are sites available that do
this but I've just tried to use Excel more and more recently as I know
its a good program that I could do with learning to use.

My problem is that in a Test series, there may be multiple Tests (four
in the current one with Pakistan), then in each Test there will be up
to four innings, and in each of the innings there will be bowling
statistics and batting statistics. So for each Test there would be a
few sheets for each one, if it was to be as well presented as I am
hoping.

So, is there any way to group sheets in a way that shows the group asa
tab, then when you click on the tab the individual sheets' tabs appear
for it? So i could have tabs that had, for example:

1st Test
2nd Test
3rd Test
4th Test
Averages

Then, if I were to click on the 1st Test, I could have:

1st England innings
1st Pakistan innings
2nd England innings
2nd Pakistan innings

Would this be possible in any way?

Thanks for any help.


--
thebottomline
------------------------------------------------------------------------
thebottomline's Profile: http://www.excelforum.com/member.php...o&userid=35290
View this thread: http://www.excelforum.com/showthread...hreadid=568699