Extened Pivot

  • Thread starter Thread starter djc
  • Start date Start date
D

djc

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?
 
Use the 'Nultiple Consolidation Ranges' option when building your Pivot Table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot from all sheets 1
Pivot Table - include multiple worksheets with different ranges. 1
Retrieving multiple rows of data 2
Pivot Table - 3
Is there a way to keep pivot tables from grouping rows with same n 1
about pivot table 1
Adding to an existing Pivot Table 7
Pivot tables - adding dates, descriptions 1

Back
Top