Arvi, tks for the answer....I have about 400 transactions every
month...as I said in another post it would be ok to have them in a
single page...about 5000 entries a year...my secretary will say she
doesn't like to write again and again for example "July".... :-(

Arvi Laanemets wrote:
Hi

How much entries do you have for every month? Thousands? When not, then I
advice a single data entry sheet (when you have some date column, then it'll
be simply, otherwise you have to add some date column p.e. with 1st of month
in it) + several report sheets, where reports are calculated accordingly
selected conditions. How exactly, depends on your data structure, and on
what you want to get.


Arvi Laanemets


wrote in message
ps.com...
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