Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table in Excel 2000
I have an excel document with 6 spreadsheets. Eevery spreadsheet contains
some common columns and some not. I am looking to do the following: 1. Create pivot table spreadsheet based on three common columns across spreadsheets. 2. The page drpop down box is going to reflect the distinct value of column 1.(It could be all) 3. The row value is represented by column 3 4. The column identified by the drop down of distict values of colum2.(it could be all) 5. The value is the count based on grouping of column 1,2,3. I am able to do this for one spreadsheet. How do you do it for 6? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Improvements in Excel Pivot Table | Excel Discussion (Misc queries) | |||
pivot table | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pivot Table "Show All" Check Box missing in Excel 2000 | Excel Worksheet Functions |