Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab in a Tab?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab in a Tab?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab in a Tab?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|