Can i set up tabs within tabs on Excel?

[Guest]

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?

 

[Carim]

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

 

[Guest]

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]

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

 

[Dave Peterson]

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.

 

[Roger Govier]

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.