Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i set up tabs within tabs on Excel?
I am working on creating cashflows for my company. I have a monthly
spreadsheet and a weeekly spreadsheet. What i need to know is 'Is it possible to have a tab for monthly and weekly with tabs inside both for the months of the year?' As i need the monthly pages to update from the weekly pages, i assume they need to be within the same workbook? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i set up tabs within tabs on Excel?
Hi Gizelle,
You cannot have tabs within tabs ... But all your consolidation process can be done without this feature ... For example your weekly data can rest in a different workbook, since links between workbooks can perform your updates ... HTH Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i set up tabs within tabs on Excel?
Hi Carim
Next question is 'If i have 2 different workbooks for weekly & montly, how would one be updated by entering or changing information on the other? Thanks "Carim" wrote: Hi Gizelle, You cannot have tabs within tabs ... But all your consolidation process can be done without this feature ... For example your weekly data can rest in a different workbook, since links between workbooks can perform your updates ... HTH Carim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i set up tabs within tabs on Excel?
Hi Gizelle,
Well pretty simply ... With your two workbooks open type = go to second workbook, go to specific cell press enter that 's it ... HTH Carim |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i set up tabs within tabs on Excel?
Instead of using two worksheets, just put your data on a single worksheet. You
can add a column that represents the week. Then by applying data|Filter|autofilter, you'll be able to see any week you want. And by keeping the data in one location, you'll find that you can do many more things with it--including pivottables, charts. And you won't have to worry about the data getting out of sync. Gizelle wrote: I am working on creating cashflows for my company. I have a monthly spreadsheet and a weeekly spreadsheet. What i need to know is 'Is it possible to have a tab for monthly and weekly with tabs inside both for the months of the year?' As i need the monthly pages to update from the weekly pages, i assume they need to be within the same workbook? -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i set up tabs within tabs on Excel?
Hi Gizelle
What does your data look like? Can you give some examples of the layout and what you are trying to summarise. It may well be that you could achieve what you want without resorting to 12 monthly tabs and 53 weekly tabs. There is no problem with having this number of tabs within a workbook though, and I find it far easier when carrying out further data manipulation to have all data in the same workbook. There is, however, nothing preventing you from using multiple workbooks to hold the data. -- Regards Roger Govier "Gizelle" <Gizelle @discussions.microsoft.com wrote in message ... I am working on creating cashflows for my company. I have a monthly spreadsheet and a weeekly spreadsheet. What i need to know is 'Is it possible to have a tab for monthly and weekly with tabs inside both for the months of the year?' As i need the monthly pages to update from the weekly pages, i assume they need to be within the same workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Code to create tabs in single excel sheet | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Copying Tabs in Excel | Excel Discussion (Misc queries) | |||
In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions |