Excel: 12 months+ 36 pivot = 48 sheets...can I simplify it?
Hello!
I have one sheet per month collecting data from different bank accounts
and that equals to 12 sheets.
For each month I have 3 pivot collecting and showing data each of them
in a different sheet equal to 36 sheets in total.
The problem is that it is hard to navigate those pages using the tabs
under the sheet.
I tried to simplify it reducing the number of pages: I have put the 3
pivot directly on the month page, just right of the bank account data.
In this case I have a problem because when I select a bank row to copy
it I also select the pivot data and that is not what I want.
So, the question is: how to make it easy? I'd like to reduce the number
of pages having each month data and pivots on the same page or....?
I saw people having a universe in a single page but how to navigate it?
Tks,
Ataru
|