ExcelBanter - Extened Pivot

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

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

- - Extened Pivot (https://www.excelbanter.com/excel-discussion-misc-queries/217906-extened-pivot.html)

djc

Extened Pivot

I have 2 sheet wheet containing 1sheet, 65000 rows and 2nd sheet 45000 rows
with same heading.
Is there a way to run pivot combining 2 seperate sheets? or even on 2
seperate files?

Gary Brown[_4_]

Extened Pivot

Use the 'Nultiple Consolidation Ranges' option when building your Pivot Table.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown

"djc" wrote:

I have 2 sheet wheet containing 1sheet, 65000 rows and 2nd sheet 45000 rows
with same heading.
Is there a way to run pivot combining 2 seperate sheets? or even on 2
seperate files?

All times are GMT +1. The time now is 10:36 PM.