| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables with Multiple Lists
I am trying to create a pivot table report whch uses data from two separate
spreadsheets (Excel 2000). Is there any way to combine two page fields into one, e.g.; the first spreadsheet has data from the year 2000-2001 and the second sheet has the same type of data for the years 2002-2003. I would like to create a pivot table report which combines both year ranges into one page field? Can anyone help? Thx, -- LPS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep file sizes small when using multiple pivot tables? | Excel Discussion (Misc queries) | |||
| Multiple Pivot Tables with single Page Field | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
| Pivot Tables multiple data fields | Excel Worksheet Functions | |||
Threaded Mode
