pivot

  • Thread starter Thread starter Malik
  • Start date Start date
M

Malik

hi, how can i build a pivot for data in two or more sheets in the same
workbook?
if i cant make a pivot, what are the possible alternatives to consolidate
the data.

thanks in advance.
 
You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

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

Perhaps you could store all your data on one sheet, or in a database,
and create the pivot table from that.
 

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 tables 2
One pivot table cannot overlap another pivot issue. 1
Pivot Table - Changes 5
Pivot table - multiple data sources 2
Pivot table filter list - listing irrelevant subcategorys 1
Pivot from all sheets 1
pivot table data 2
Pivot table not recognizing same field values 1

Back
Top