Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table error when Opening an Xml Spreadsheet from MS excel Xp | Charts and Charting in Excel | |||
Excel 97 Question (Pivot tables) | Excel Discussion (Misc queries) | |||
Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |