Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do a pivot table using data from 2 worksheets/tabs in a
spreadsheet. I am using Excel 2000

I have about 75000 lines of data which I have split onto two
worksheets/tabs. The column headings are identical in both worksheets/tabs.

I tried a range of sheet1!$A$1..$G$40000;sheet2!A$1..$G$35000 but I get
"reference is not valid"
 
You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a single worksheet, or in a database,
and you'll have more flexibility in creating the 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 Table with Data Model Connection - getpivotdata reference issue 0
Scrabble Value calculation for Welsh words 0
Pivot table data source 1
Workbook pivot table design function 6
Creating pivot table to Existing worksheet 1
Pull data from different worksheets/tab into one Pivot Table 3
pivot table 1
Pivot Tables 3

Back
Top