ExcelBanter - Tab in a Tab?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Tab in a Tab? (https://www.excelbanter.com/excel-worksheet-functions/175208-tab-tab.html)

Is it possible to have tabs inside other tabs? I want to have 12 tabs for the
months and then 4 tabs inside of those 12. I would also like to take the
total from the tabs inside and put them on the monthly tab. This is for
simple sales tracking for 4 people. Can anyone help me? I have the 4 tabs I
need all set, now I just need help with the monthly tab. I can email someone
a copy of what I have if it helps.

Thanks in advance.

Is it possible to have tabs inside other tabs?
No, not in the literal sense of it as you put it.
You could always set-up the summary in another sheet

Post a link to your sample* file here.
This way, the ensuing discussions
stays visible to all who may be interested.

You could use:
http://www.freefilehosting.net/

*desensitized as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Swagfu" wrote in message
...
Is it possible to have tabs inside other tabs? I want to have 12 tabs for
the
months and then 4 tabs inside of those 12. I would also like to take the
total from the tabs inside and put them on the monthly tab. This is for
simple sales tracking for 4 people. Can anyone help me? I have the 4 tabs
I
need all set, now I just need help with the monthly tab. I can email
someone
a copy of what I have if it helps.

Thanks in advance.

You cannot have worksheets inside worksheets which is what you are asking for.

Could you just assign 4 ranges on each sheet to each of your 4 people?

If using Excel 2003 you could create 4 list ranges on each sheet.

DataListCreate List

And there is always good old DataFilter. Either Auto or Advanced.

Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 14:51:02 -0800, Swagfu
wrote:

Is it possible to have tabs inside other tabs? I want to have 12 tabs for the
months and then 4 tabs inside of those 12. I would also like to take the
total from the tabs inside and put them on the monthly tab. This is for
simple sales tracking for 4 people. Can anyone help me? I have the 4 tabs I
need all set, now I just need help with the monthly tab. I can email someone
a copy of what I have if it helps.

Thanks in advance.