I apologise in advance
 

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

I apologise in advance
 

There is no built-in way to group tabs like that, but I have to ask, why do
you need separate tabs for one test. I would lay it out such that I had the
four innings as separate tables on the sheet, the bowling and batting
statistics as related but separate tables (again per innings), and then
summary. Add a few buttons and you could easily display the relevant part.
Personally, I think that I would try and keep it to one tab per test match
and use navigation aids.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"thebottomline"
wrote in message
news:thebottomline.2c3daj_1154822711.4345@excelfor um-nospam.com...

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