Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have a fairly large dataset which spans several worksheets. Each ws have
identical used ranges with identical columns headers representing different variables. Each ws have identical first columns representing f.i. time stamps. Is it possible to construct a pivot table which 1) Use data from all the different worksheets as its source data 2) Use the individual ws names in one page field 3) Use the common column headers in a second page field 4) Use the common first column as a row field 5) Individually displays values for one or more selected column headers across selected sheets If it is I'd appreciate indication to where I can find info leading me in the right direction. ojv |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |