Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidate data in pivot table
I would like to consolidate the data from several worksheets into one pivot
table. All of the worksheets have the same number of columns with the same column labels but each table has a different number of rows with various entries in column 1 of each row. Column 1 contains peoples names and the people involved can change each time the data is collected. The names may repeat in one worksheet and they may or may not appear on every worksheet. Ultimately I would like to create a chart that shows the trend for a person from month to month. -- Vickie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate Pivot table from multiple files | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Using Pivot Table to consolidate multiple worksheets | Excel Discussion (Misc queries) | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions |