Does anyone know how to create a pivot table using multiple ranges? I have a large amount of data that fills 4 worksheets and has 16 columns. The headers/labels for each column are identical. When I use "Multiple Consolidation Ranges" from the Pivot Table Wizard the field options are not my headers (as would be on a normal Pivot Table), rather the only headings I have available are "Row" and "Column." I need to be able to summarize this massive amount of data and have the options to use only the fields/headers I desire. The data is as consolidates as it is going to get. I guess with this amount of data the drill down function of the pivot table might not work since certain items that are drilled down on might easily take up more than one sheet.
I have tried numerous times to get the multiple consolidation ranges to work and have had no luck. I'm beginning to think that Access might be my last option. I would rather use an Excel Pivot Table. I've talked to others and the word I got from them was that the Multiple Consolidatoin Ranges function does not work. I'm hoping someone here might know how to get it to work.
Thanks!
I have tried numerous times to get the multiple consolidation ranges to work and have had no luck. I'm beginning to think that Access might be my last option. I would rather use an Excel Pivot Table. I've talked to others and the word I got from them was that the Multiple Consolidatoin Ranges function does not work. I'm hoping someone here might know how to get it to work.
Thanks!