ExcelBanter - Pivot Table Consolidating multiple ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Consolidating multiple ranges (https://www.excelbanter.com/excel-discussion-misc-queries/261467-pivot-table-consolidating-multiple-ranges.html)

Jen_T

Pivot Table Consolidating multiple ranges

In Excel 2003 users were able to consolidate multiple ranges when craeting a
pivot table. Is there a way to do this in Excel 2007 ?

Roger Govier[_8_]

Pivot Table Consolidating multiple ranges

Hi

Alt+D+P will bring up the old Wizard
--
Regards
Roger Govier

Jen_T wrote:
In Excel 2003 users were able to consolidate multiple ranges when craeting a
pivot table. Is there a way to do this in Excel 2007 ?

All times are GMT +1. The time now is 02:17 AM.